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).

Type some number and try restarting

this worked for me and restarted once.

2.This can be due to the files / folder permissions and owner of the mysql folder.

If you still face the issue, try killing the mysql process

Then, try

3.This can be /tmp permission issues.
or /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’

Then, Try

Thats it, make sure you do take backups of the files before  you start working.
if you face

About ilangovan ramasamy

I am a IT manager on a Corporate co. Started My Career In a Internet Center. having 10 years on Experience on IT. Very much Interested in knowing New technologies & gadgets. Wrote many Articles & how to’s for Computer Related issues. As I am in to hosting industry We face many issues on work. I thought of sharing my knowledge with you and writing so. If you guys feel something is interesting & helpful, Please do comment on it.

View all posts by ilangovan ramasamy →

Comments