出现MySQL manager or server PID file could not be found!是什么原因?

使用Llsmp添加ftp账户的时候(vsftpd)出现以下情况:

1
2
3
 * MySQL manager or server PID file could not be found!
Starting MySQL
. * Manager of pid-file quit without updating file.
使用命令:

1
ps -A|grep mysql
查出以下进程在运行

1
12475 ?        00:00:02 mysqld
果断的

1
Kill 12475
然后重启Mysql,恢复正常:

1
/etc/init.d/mysql start
看到以下显示即成功
Starting MySQL
[root@centos var]# service mysqld stop

MySQL manager or server PID file could not be found!       [FAILED]
解决办法:
首先查看一下进程
[root@centos mysql]# ps aux |grep mysq*
root      2643  0.0  0.2   4536  1224 ?        S    01:09   0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/centos.pid
mysql     2757  0.0  1.2  36976  6608 ?        Sl   01:09   0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/centos.err --pid-file=/usr/local/mysql/var/centos.pid --socket=/tmp/mysql.sock --port=3306
root      4788  0.0  0.1   3920   684 pts/2    R+   11:11   0:00 grep mysq*
如果看到上面的内容,那说明,Mysql的进程卡死了,这时用就要把这些卡死的进程都关闭
[root@centos mysql]# kill 2643
[root@centos mysql]# kill 2757
pkill mysql 
启动Mysql 就ok了

[root@centos mysql]# service mysqld start
Starting MySQL.
————————————————
版权声明:本文为CSDN博主「白及」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/u010098331/article/details/50752645

  

原文地址:https://www.cnblogs.com/jthb/p/14970820.html