Shutting down MySQL ERROR!

linux / 2023年03月21日 20时17分 / 2749人浏览
今天在服务器查看mysql状态的时候看到很多语句等待时间过长,重启mysql的时候却报错ERROR! Failed to stop running server, so refusing to try to start,接下来为大家介绍一下解决方法,有需要的小伙伴可以参考一下: 1、错误提示
[root@localhost ~]# service mysql restart
Shutting down MySQL....................................................................................
.......................................................................................................
.......................................................................................................
.......................................................................................................
................................................................................................ ERROR!
ERROR! Failed to stop running server, so refusing to try to start.
2、解决方法: 输入命令找到对应的进程,然后kill -9杀掉对应的进程
[root@localhost ~]# ps -ef | grep mysql