ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.0.1' (113)

Published November 3rd, 2011

How to solve MySQL Error 2003 (HY000) when trying to connect to a MySQL server on a remote machine?

This error occurs when the mysql client cannot open the TCP connection to the remote DB server.

Make sure you are specifying the host and port correctly:

mysql -h 10.0.0.1 -P 3306 -u chris

Try to connect using telnet to check if the port is open and not blocked by a firewall:

telnet 10.0.0.1 3306

If this works then your MySQL connection details are incorrect (wrong user?)

If this does not work then it is a network problem and not a MySQL problem. Try checking your firewall to make sure that the client machine is permitted access to the MySQL port on the database server.