[root@centos var]# service mysqld stop
MySQL manager or server PID file could not be found! [FAILED]
解決辦法:
首先查看一下進(jìn)程
[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*
如果看到上面的內(nèi)容,那說明,Mysql的進(jìn)程卡死了葛账,這時(shí)用就要把這些卡死的進(jìn)程都關(guān)閉
[root@centos mysql]# kill 2643
[root@centos mysql]# kill 2757
啟動(dòng)Mysql 就ok了
[root@centos mysql]# service mysqld start
Starting MySQL.