首页 > 代码库 > mysql 启动错误 - server PID file could not be found

mysql 启动错误 - server PID file could not be found

[root@centos var]# service mysql stop
MySQL manager or server PID file could not be found! [FAILED]
 
解决办法:
首先查看一下进程
[root@accenture /]# ps aux |grep mysq*
root 10274 0.0 0.0 68160 1336 ? S 13:43 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/irxpert-test.pid mysql 10353 0.0 1.0 344360 39464 ? Sl 13:43 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/irxpert-test.err --pid-file=/var/lib/mysql/irxpert-test.pid root 11884 0.0 0.0 63384 760 pts/1 S+ 15:44 0:00 grep mysq*
如果看到上面的内容,那说明,Mysql的进程卡死了,这时用就要把这些卡死的进程都关闭
[root@centos mysql]# kill 10274
[root@centos mysql]# kill 10353
启动Mysql就ok了
[root@centos mysql]# service mysql start
Starting MySQL. [ OK ]

mysql 启动错误 - server PID file could not be found