700字范文,内容丰富有趣,生活中的好帮手!
700字范文 > Mysql ERROR 2002 (HY000) Can't connect to local MySQL server through socket

Mysql ERROR 2002 (HY000) Can't connect to local MySQL server through socket

时间:2020-05-15 22:46:29

相关推荐

Mysql ERROR 2002 (HY000) Can't connect to local MySQL server through socket

为什么80%的码农都做不了架构师?>>>

You may face this error while restarting MySQL. Below are some fix for the same. [root @server :~ ] $ service mysqld start Starting MySQL... ERROR! The server quit without updating PID file This error can be de to different reasons. 1. Check if there is any running MySQL process by using the following commands and kill all and restart. ps aux | grep mysql If you are able to see any mysql process like below, just kill that process. root @server [~]# ps aux | grep mysql root 1140 0.0 0.0 4140 676 pts/0 D+ 22:34 0:00 grep mysql root 2987 0.0 0.0 4736 1288 ? S Sep27 0:00 /bin/sh /usr/bin/mysqld_safe Now kill it. kill -9 2987 Make sure that there is no mysql process running at this point. Restart MySQL. service mysqld restart 2. If the above fix is not working, now we can try some more. It can be due to some conflicting entries in f Try moving the mysql config file /etc/f file and restart mysql. mv /etc/f /etc/f.backup Restart mysql. service mysqld restart 3. If none of the above is working, try to move the log file named “ib_logfile” in “/var/lib/mysql” and restart mysql. Sometimes mysql will fail because it face difficulty updating the log file. mv /var/lib/mysql/ib_logfile* /root/ Restart and see the results. service mysqld restart You can also remove ib_logfile as it will be created automatically after mysql restart. Hope this helps.

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。