How to deal with mysql connection Times ERROR 2002 (HY000) error

The following brings you mysql connection Times ERROR 2002 (HY000) error how to deal with the relevant content, I believe you must have read a similar article. What's the difference between what we bring to everyone? Let's take a look at the text. I'm sure you'll get something after reading the mysql connection Times ERROR 2002 (HY000) how to deal with errors.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ var/lib/mysql/mysql.sock' (2) reason for modifying my.cnf configuration file

Modifying the location of socket attributes under mysqld results in

Solution

Add client configuration, where the socket path is the same as mysqld

[client]

Socket=/var/lib/mysql_xx/mysql.sock

It can be solved after restarting the service.

For the above about the mysql connection Times ERROR 2002 (HY000) error how to deal with, do you think it is what you want? If you want to know more about it, you can continue to follow our industry information section.