mysql 2003 111,错误2003（HY000）：无法连接到“ 127.0.0.1”上的MySQL服务器（111）

I use the following command:

mysql -u root -h 127.0.0.1 -p

and the error message is :

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

Who can help me to fix it?

解决方案

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

run the command vim /etc/mysql/my.cnf

comment bind-address = 127.0.0.1 using the # symbol

restart your mysql server once.

Update

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 IP for which MySQL server is bind in 'my.cnfinstead oflocalhost or 127.0.0.1`.