Can’t Connect to MySQL having it listen to external IP

Unix

11 Apr 2016

Can’t Connect to MySQL having it listen to external IP

Preston Garrison 0 Comments

If you see the error:

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

and you are on a freshly installed server, more then likely you haven’t set up mysql to listen on the external ips. The easy way to fix this is to just comment out the line:

bind-address = 127.0.0.1

It will now listen on all ports and ips..