Starting MySQL. ERROR! The server quit without updating PID file 1

Starting MySQL. ERROR! The server quit without updating PID file

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.
MySQL ERROR! The server quit without updating PID or Can’t create file ‘tmp’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

Comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.