Tuesday, April 21, 2009

Mysql connection error 2003 (HY000) (146)

Tried logging into a remote mysql server and got an error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'someserver' (146)
In this case, it was due to bind-address being set to 127.0.0.1in the /etc/my.cnf file (/opt/local/etc/my.cnf). The issue arose on a machine that used to be a slave after I had converted it back into a stand alone mysql server.

No comments:

Post a Comment