socket文件路径配置错误,该问题一般是由于修改mysql的配置文件my.conf导致,修改正确即可。
1、首先命令行判断mysql是否正常启动,输入命令ps -ef | grep mysql回车。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8c1001e93901213fbcd011b85be736d12e2e95f6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后更改my.cnf文件,我的服务器中的目录为/etc/my.cnf,如果没有的话可以用find去查找。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/94cad1c8a786c9173deb0d5dc63d70cf3ac757ed?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后新建一个/var/run/mysqld目录,mysqld服务重启需要这个目录,命令行输入下图红框中命令。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c3387443b8071185e0fd9f9d72aa009?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、tmp目录下就有了my.cnf配置文件中需要的mysql.sock文件了,然后把my.cnf改回如下图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc40cc1ea9f36dbb6fd526633ab?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、mysql应该已经完全修复了,那么我们再测试一下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b03533fa828ba61e9ed6914b4e34970a304e599d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)