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