So many users face difficulty due to below error:
service mysql start
Starting MySQL… ERROR! The server quit without updating PID file
Starting MySQL… ERROR! The server quit without updating PID file
You can see this error while restarting MySQL server,Below are some fixes for this error.
First of all Check if there is any running MySQL process by using the following commands and kill all and restart.
ps aux | grep mysql
Make sure that there is no MySQL process running at this point. Restart MySQL.
service mysql restart
Second it can be due to some conflicting entries in my.cnf
Try moving the MySQL config file /etc/my.cnf file and restart MySQL
mv /etc/my.cnf /etc/my.cnf.backup
Again restart MySQL
service mysql restart
If none of the above is working you may try moving the log file “ib_logfile” in “/var/lib/MySQL” and restart MySQL. Sometimes MyQL fails because it face difficulty updating the log file.
mv /var/lib/mysql/ib_logfile* /root/
Restart and check the results.
service mysql restart
You may also remove ib_logfile as it will be created automatically after MySQL restart.
Previously we have talk about MYSQL ERROR CODE:24,You can also check that.
Hope these steps will help to resolve the error.