Troubleshoot MySQL Manager or server PID file could not being found! The method

[[Email protected] var]# service mysqld stop

MySQL Manager or server PID file could not being found! [FAILED]

Workaround:

First look at the process

[[Email protected] 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*

If you see the above, it means that the MySQL process is dead, and then it's time to shut down all the dead processes.

[[email protected] mysql]# kill 2643

[[email protected] mysql]# kill 2757

It's OK to start MySQL.

[[Email protected] mysql]# service mysqld start

Starting MySQL.

This article is from the "Mr. Chancellor's Blog" blog, please be sure to keep this source http://chaohuang.blog.51cto.com/6843018/1895386

Troubleshoot MySQL Manager or server PID file could not being found! The method