connection to dat Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

「已注销」

于 2016-03-03 13:16:12 发布

阅读量5.5k

点赞数

分类专栏： Linux|故障排除 Web服务器|故障排除|性能优化

本文链接：https://blog.csdn.net/u010098331/article/details/50787771

版权

本文记录了Zabbix无法连接到本地MySQL服务器的问题，错误提示为'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'。通过查找日志和系统文件，发现mysql.sock位于/tmp目录下。解决方法是创建软链接ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock，并重启mysqld服务，成功解决了连接问题。

摘要由CSDN通过智能技术生成

[root@t1 ~]# tail /tmp/zabbix_server.log
23392:20160303:131022.598 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
23392:20160303:131022.598 Database is down. Reconnecting in 10 seconds.
23392:20160303:131032.598 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
23392:20160303:131032.598 Database is down. Reconnecting in 10 seconds.
23392:20160303:131042.599 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
23392:20160303:131042.599 Database is down. Reconnecting in 10 seconds.
23392:20160303:131052.599 [Z3001] connection to database 'zabbix' failed: [2002] C