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

最新推荐文章于 2024-07-25 09:51:34 发布

mcatto

最新推荐文章于 2024-07-25 09:51:34 发布

阅读量1.8k

点赞数

分类专栏： MySQL 文章标签： MySQL mysql.sock Cant connect

本文链接：https://blog.csdn.net/fly_leopard/article/details/72896931

版权

MySQL 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

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就可以了