Skip to main content

how can i connect to remote database from netbeans

2 replies [Last post]
appserver_user
Offline
Joined: 2006-10-17
Points: 0

Hi,

I have got MySQL database server installed and running on a different machine. Is there any way to connect and browse database remotely using netbeans 5.5?

I have added connector/driver for that database. i can connect and browse the database with host: "localhost" and port number. But when i specified the ip address of that machine, it gives me error.

Can anyone help please.

cheers.

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
tasza
Offline
Joined: 2006-10-20
Points: 0

Hi,
As Mithat said - please tell us more about this error.
I've tested connection to my remote db (www.freesql.org)
using host name as well as IP number...it worked for me.
I have NB5.5RC1 and this MySQL connector:
http://dev.mysql.com/downloads/connector/j/5.0.html
Hmm, please verify port number used by your db server.
It's usually 3306, but not always...

And one additional test: try to verify if connection is
possible at all using any other mysql client...

Natasza

mithatk
Offline
Joined: 2005-09-19
Points: 0

Until now, you might have solved your problem.

If you have not, please give more detail about the error.

Also, have you tried to ping mysql server's ip address from your computer?

Mithat