Sometimes when you start MySQL server, you may get the error ‘Server Quit Without Updating PID File’ in MySQL, and the server may not start at all. In this article, we will learn how to fix this problem. This can occur in Linux, Mac or Windows.
How to Fix ‘Server Quit Without Updating PID File’ MySQL Error
Here are the steps to fix ‘server quit without updating PID file’.
First of all, look for .err file in MySQL directory. It is generally found in
/usr/local/var/mysql/<your_computer_name>.err
This is where you will find more information about the error. Open it with a text editor to view details about the issue.
If it is a permission related problem, then check if any other MySQL instance is running on your server. Perhaps there is another MySQL process already running and therefore your new process is unable to use the port.
$ ps -ef | grep mysql
If you see any processes listed in the output of above command, note their PIDs. It is mentioned next to username column of output. Then kill those processes using kill command and the PID you just noted.
$ kill -9 PID
Next, check the ownership of /usr/local/var/mysql/
$ ls -laF /usr/local/var/mysql/
If it is owned by root, change its owner to mysql or your username, using the following command.
$ sudo chown -R mysql /usr/local/var/mysql/
Sometimes you may need to restart MySQL server to apply changes. Sometimes you may also need to delete the .err file we mentioned above to get things working.
$ sudo rm -rf /usr/local/var/mysql/your_computer_name.err
In this article, we have learnt how to fix ‘Server Quit without Updating PID File’ issue.
Also read:
How to Change Apache Config Without Restarting
How to Change NGINX Config Without Restarting
How to Get Selected Text from Dropdown in jQuery
How to Get Data-Id Attribute in jQuery
How to Check if Image is Loaded in jQuery/JavaScript