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

分类: IT文章 • 2022-03-31 13:36:35

重启mysql服务器后报:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

原因my.cnf配置文件加了 socket = /usr/local/mysql/mysql.sock

注释后解决

新解决方法

mysql安装目录bin/mysql_config默认的socket路径是/tmp/mysql.sock

socket=' /tmp/mysql.sock'

将my.cnf配置文件的修改未一样的路径即可

[client]
socket = /tmp/mysql.sock
[mysql]
socket = /tmp/mysql.sock