ERROR 2003 (HY000): Can’t connect to MySQL server on ‘IP’ (111)

You might have noticed this error while connecting to a remote database server from other machines (different IP). See the below steps to resolve the issue.

1. Check the /etc/my.cnf configurations

2. Comment the bind IP line as below  :

# bind-address=127.0.0.1

which allows machines from other IPs to connect into this database server.

 

Enjoy ! 🙂

Advertisements

2 thoughts on “ERROR 2003 (HY000): Can’t connect to MySQL server on ‘IP’ (111)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s