MySQL stopped running due to improper shutdown or abrupt close of the query. To start the MySQL service, please use the following reasons and solutions.
MySQL not start due to existing lock file
# servicemysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
Above command will shows that the MYSQL is not running. We have ran following command to remove the lock file.
# rm /var/lock/subsys/mysql
Then, we restarted the MySQL service using the following command:
# servicemysqld restart
This fixed the error.