Fix ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (111)

Problem :

Continuing from previous tutorial on how to fix access denied to root connecting remotely error 1045. This time is another error message that was caused by default MariaDB/MySQL server setting.

ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (111)

Solution :

The default setting of MariaDB/MySQL server will not allow access with mysql tool from remote machine. Check the MariaDB/MySQL server's configuration file

either /etc/my.cnf or /etc/mysql/my.cnf

to see if there is a bind-address parameter in there. For example,

bind-address = 127.0.0.1

If there is a bind-address parameter in my.cnf file, this instruct the server to accept mysql tool connection from localhost or 127.0.01.

To change and allow remote access, you can either remove the bind-address parameter or comment it out.

Remember to restart MariaDB/MySQL for the changes to take effect.

>sudo /etc/init.d/mysql restart

Shutting down MySQL. SUCCESS!

Starting MySQL.. SUCCESS!

Hope this helps!