PDA

View Full Version : remote mysql connection


speedy
2nd August 2009, 20:54
Hi All,

I'm strugeling with creating a mysql connection from my home pc to the external server.
I can telnet to my server. on port 3306 So that is fine. (Also from the server itself I can connect to the datasebase with the user test)
I have a user "test" (localhost, and *). Without a password for testing purposes.
But when I try to login I keep getting this error:

C:\Users\Tom>mysql -u test (IP)
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I hope you can help me.

Thanks

falko
3rd August 2009, 10:48
You must specify the host:
mysql -u test -h <hostname>