Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

最新推荐文章于 2025-11-03 23:32:00 发布

原创最新推荐文章于 2025-11-03 23:32:00 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #mysql.sock #Cant connect

MySQL 专栏收录该内容

15 篇文章

订阅专栏

本文介绍了当MySQL自定义了mysql.sock路径后，如何避免因my.cnf配置不完整导致的连接错误2002。通过正确配置my.cnf文件中的socket路径，可以解决mysqldump、mysqladmin等工具无法连接本地MySQL服务器的问题。

MySQL自定义了mysql.sock和data文件位置以后，重启如果my.cnf配置不完整会导致如下：

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect

或者

mysqladmin: Got error: xxxx: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect

或者
mysql: Got error: xxxx: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect

需要在my.cnf中告诉这些可执行文件sock在哪，：

[mysql]
socket=/usr/local/web/data/mysql.sock
[mysqladmin]
socket=/usr/local/web/data/mysql.sock
[mysqldump]
socket=/usr/local/web/data/mysql.sock

重启MySql就可以了