The database reports an error "ERROR! MySQL server PID file could not be found!"

Today, I saw a customer trying to solve a problem because he couldn't start the database when he was processing it. Then I saw the error "ERROR! MySQL server PID file could not be found!".

 [ root@VM-0-5-centos  ~]# /etc/init.d/mysqld restart ERROR!  MySQL server PID file could not be found! Starting MySQL…. ERROR!  The server quit without updating PID file (/www/server/data/VM-0-5-centos.pid).

The problem is:

The MySQL log file is missing or corrupt.

We'd better take a snapshot backup before processing.

 /etc/init.d/mysqld stop  rm -f /www/server/data/ib_logfile*  rm -f /www/server/data/mysql-bin.*  /etc/init.d/mysqld start

Try to see if it has been solved.