Are you interested for monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more ? please check our Monthly server support plans
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,
[email protected] [~]# /etc/init.d/mysql start Starting MySQL.. SUCCESS! [email protected]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 NowView Server Administration Packages