Starting MySQL. ERROR! The server quit without updating PID file
There are few reason, why you get this error message.
This can be due to the mysqld was killed unexpectedly and unable to restart
This can be due to the files / folder permissions of the mysql folder.
This can be /tmp permission issues.
we are going to address one by one and resolving the issues.
1.This can be due to the mysqld was killed unexpectedly and unable to restart
You can either create a file named (/var/lib/mysql/***.***.com.pid).
server # touch /var/lib/mysql/servername.example.com.pid server # nano /var/lib/mysql/servername.example.com.pid
Type some number and try restarting
server #service mysql restart
this worked for me and restarted once.
2.This can be due to the files / folder permissions and owner of the mysql folder.
server # chown -R mysql:mysql /var/lib/mysql server # chmod 755 /var/lib/mysql
If you still face the issue, try killing the mysql process
server #killall -s KILL mysqld
Then, try
server #service mysql restart
3.This can be /tmp permission issues.
or /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’
server # chmod 777 /tmp server # chmod 777 /var/tmp
Then, Try
server #service mysql restart
Thats it, make sure you do take backups of the files before you start working.
if you face