My MySQL server is running on Centos and it is not restarting and giving following error:
Starting MySQL....The server quit without updating PID file (/var/lib/mysql/xxxxx.pid).
MySQL Restart fails and the server quit without updating PID file. What is reason?
The reason is that there is some error in my.cnf file.
You should replace the my.cnf with correct version of my.cnf file.
Check the tutorial: cPanel upgrade MySQL 5.1 to 5.5.
You should rename the file using following command:
mv /etc/my.cnf /etc/my.cnf.old
and then try to restart the MySQL Server.
Even if does not starts you should copy the my.cnf file from the directory of your MyServer.
In case of MySQL 5.5 you can use following command:
cp /usr/share/mysql/my-small.cnf /etc/my.cnf
and then change the permission using following command:
cd /etc/ chown -R mysql:mysql my.cnf