Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

ERROR 2002 (HY000):Can’t connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock’解决方案(Ubuntu)

当mysql不能登录的时候使用以下方法解决:

1. 在终端查看mysql相关进程号

ps -u mysql(登录不上的时候可能会有多个与mysql相关的进程)
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

2. 查看进程号,将这些进程全部杀死

kill 9543
可以再次执行ps -u mysql 查看是否成功杀死

3. 随后重启mysql

service mysql start

4. 尝试登录

mysql -uroot -p
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
发现登录成功