ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Question

I got the following error when checking the status of MySQL, and if i restart the MySQL also returns the same one.....

# service mysql status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL.... ERROR! The server quit without updating PID file

jagannath arumugam · Answer

Run the below command to remove the lock file and restart the service.

# rm /var/lock/subsys/mysql

If not started then it means that MySQL was not stopped properly, so check it with ps or lsof command and kill it.

Once it is done, restart the service and check. It will work fine..!!!