Re: Error logging into Remote MySQL

[Umesh Shastry]

Hi!!

[From Docs]

If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is:

*

Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key a couple of times. (3306 is the default MySQL port number. Change the value if your server is listening to a different port.) If there is a MySQL server running and listening to the port, you should get a response that includes the server's version number. If you get an error such as telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port.
*

If the server is running on the local host, try using mysqladmin -h localhost variables to connect using the Unix socket file. Verify the TCP/IP port number that the server is configured to listen to (it is the value of the port variable.)
*

Make sure that your mysqld server was not started with the --skip-networking option. If it was, you cannot connect to it using TCP/IP.
*

Check to make sure that there is no firewall blocking access to MySQL. Applications such as ZoneAlarm and the Windows XP personal firewall may need to be configured to allow external access to a MySQL server.

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221