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

If you are using Ubuntu, you have to use the following steps to avoid this error (if there is no replication enabled):

1. run the command vim /etc/mysql/my.cnf
2. comment bind-address = 127.0.0.1 using the # symbol
3. restart your MySQL server once.

In Step 1, if you cannot find bind-address in the my.cnf file, look for it in /etc/mysql/mysql.conf.d/mysqld.cnf file.

Update in case of MySQL replication enabled

Try to connect MySQL server on the IP address for which MySQL server is bound in file my.cnf instead of localhost or 127.0.0.1.