Most affordable 24×7 server management plan including 24×7 monitoring, security audit and much more  Server Management Services 

The server quit without updating PID file MySQL RESTART ERROR

This error may happens while restarting msql service,

Also you can see the error ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists while checking the status of mysql.

In this case you just need to remove the lock file /var/lock/subsys/mysql then try restarting the mysql service again,

Sometimes you will again see an error The server quit without updating PID file. This time you need to locate the mysql process and kill it.

Then restart mysql service again,

root@iserversupport [~]# /etc/init.d/mysql start
Starting MySQL.. SUCCESS!
root@iserversupport[~]#

Still you are facing any issue then check the mysql logs and check the error in logs,

 

An example log
—————
120122 10:55:22 [ERROR] /usr/sbin/mysqld: unknown variable ‘set-variable=max_user_connections=40′
120122 10:55:22 [ERROR] Aborting

120122 10:55:22 InnoDB: Starting shutdown…
120122 10:55:22 InnoDB: Shutdown completed; log sequence number 2153996
120122 10:55:22[Note] /usr/sbin/mysqld: Shutdown complete

120122 10:55:22 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
—————

Here in the logs you can see error in the first line. So you need to comment the line by editing the file my.cnf and start mqsql.

Need our help to fix the issue ? Submit Support Ticket Now