mysql使用出现错误:mysqld dead but subsys locked

现象:

  登陆时候出现如下信息

  

[root@localhost home]# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@localhost home]#

查看mysql状态:

[root@localhost home]# service mysqld status
mysqld dead but subsys locked
[root@localhost home]#

解决方法:  修改mysqld的权限

      chown -R mysql.mysql /var/run/mysqld

原文地址:https://www.cnblogs.com/givemelove/p/8214340.html