【已解决】mysql启动报错：MySQL is not running but lock file /var/lock/subsys/mysql FAILED

折腾：

【已解决】尝试解决crifan.org的WordPress网站经常出错：建立数据库连接时出错

期间，已经解决空间的问题了。

但是依旧无法启动mysql

去看看

[root@crifan ~]# service mysqld status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]

所以再去解决：

MySQL is not running, but lock file /var/lock/subsys/mysql FAILED

mysql 有报错　 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists – bass – 博客园

[MySQL] 重启MySQL提示ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql)-boyhack-51CTO博客

mysql报错：ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists – 简书

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists – CentOS

locking – Why do I get “MySQL is not running but lock exists”? – Stack Overflow

linux – MySql server PID not found – Stack Overflow

php – mysql is dead but subsys locked – Stack Overflow

Linux-mysql异常：ERROR!MySQLisnotrunning,butlockfile(/var/lock/subsys/mysql)exists_weixin_30562507的博客-CSDN博客_error!mysqlisnotrunning,butlockfile(/var/l

算了，删除试试

[root@crifan subsys]# rm mysql
rm: remove regular empty file ‘mysql’? y

然后重启

[root@crifan subsys]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL..                                           [  OK  ]

以及

[root@crifan subsys]# service mysqld status
MySQL running (5565)                                       [  OK  ]

状态正常了。

再去重启Vultr服务器

重启后

[root@crifan ~]# service mysqld status
MySQL running (4311)                                       [  OK  ]

mysql正常启动了。

【总结】

此处mysql启动报错

# service mysqld status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]

解决办法：

直接删除lock文件：

rm -f /var/lock/subsys/mysql

即可。

转载请注明：在路上 » 【已解决】mysql启动报错：MySQL is not running but lock file /var/lock/subsys/mysql FAILED

【已解决】mysql启动报错：MySQL is not running but lock file /var/lock/subsys/mysql FAILED

与本文相关的文章

Hi，您需要填写昵称和邮箱！