Mysql startup error prompt server PID file cocould not be found

[Root @ centos var] # service mysqld stop

MySQL manager or server PID file cocould not be found! [FAILED]

Solution:

First, check the process.

The code is as follows:

Copy code

[Root @ irxpert-test/] # ps aux | grep mysq * Root 10274 0.0 0.0 68160 1336? S 13:43/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/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 + grep mysq *

If you see the above content, it means that the Mysql process is stuck, and you need to close all the stuck processes.

The code is as follows:	Copy code
[Root @ centos mysql] # kill 10274. [Root @ centos mysql] # kill 10353.

Start Mysql.

The code is as follows:	Copy code
[Root @ centos mysql] # service mysql start Starting MySQL. [OK]