- 2019-08-06 centos 6 , 32bit
当尝试打开wordpress网站时 ,出
1 |
can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' |
如果直接在putty mysql -u root -p 连, 出
1 |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) |
这时查看 mysql status :
1 |
service mysqld status |
状态是 : mysqld dead but subsys locked
Google到解决方法是 : https://support.plesk.com/hc/en-us/articles/360005078273-Unable-to-start-MySQL-because-of-lack-of-RAM-mysqld-dead-but-subsys-locked-
a) 先把锁文件删除
1 |
rm -f /var/lock/subsys/mysqld |
b) free – m , 看内存可用, 如果大于200M , 就不用做其他操作, 否则杀占内存过多的进程
c) 重新启动 mysql : service mysqld start