Monday, May 23, 2011

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

root@124:/etc# mysql  -uroot -priva#secure  -h10.677.32.43
ERROR 2003 (HY000): Can't connect to MySQL server on '10.677.32.43' (111)

If you go this error. Check your /etc/my.cnf ( for centos), /etc/mysql/my.cnf ( for ubuntu)

Comment this two line.

#skip-external-locking

#bind-address           = 127.0.0.1

Restart Mysql. Now you should able to connnect remotely.