ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Cause of the problem:

It is possible that the [mysqld] parameter socket is set in the my.cnf configuration file, but the [client] parameter socket is not set.

What is the mysql.sock file used for:

mysql supports both socket and TCP/IP connections. So what is the use of the mysql.sock file? Connections to localhost are usually made through a Unix domain socket file, typically /tmp/mysql.sock. If the socket file is deleted, local clients will not be able to connect. The /tmp folder is a temporary file and may be deleted at any time.

1. TCP connection (if an error message is displayed for /tmp/mysql.sock, you can try this method to connect)

mysql -uroot -h 127.0.0.1 -p

2.Socket connection

mysql -uroot -p

Solution:

Add the [client] configuration item as shown below

Before configuration: (Before configuring [client], an error message will be reported: '/tmp/mysql.sock' (2))

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

After configuration: (After configuring [client], restart the mysql service)

[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/var/lib/mysql/mysql.sock (same as the socket path)
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
port=3306
socket=/var/lib/mysql/mysql.sock

end, this article ends, I hope it will be helpful to everyone!