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!
See also : Fix ERROR 1045 (28000): Access denied for user 'root'@'ip-address' (using password: YES)
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+11.5k Golang : Convert uint value to string type
+3.7k Golang : Qt get screen resolution and display on center example
+6.5k Golang : How to unmarshal JSON inner/nested value and assign to specific struct?
+4.7k Golang : Convert decimal number(integer) to IPv4 address
+3.7k Golang : Process json data with Jason package
+2.7k Unix/Linux : How to test user agents blocked successfully ?
+7.6k Golang : How to check if a string starts or ends with certain characters or words?
+6.3k Golang : Recombine chunked files example
+3.5k Ubuntu : connect() to unix:/var/run/php5-fpm.sock failed (13: Permission denied) while connecting to upstream
+5.5k Golang : Sort and reverse sort a slice of integers
+3.8k Golang : Create and shuffle deck of cards example