How to fix MySQL Error: The server quit without updating PID file

When using a Mac, having installed MySQL using Homebrew, you may run into an error as follows when trying to start MySQL perhaps after changing some MySQL configuration:

. ERROR! The server quit without updating PID file (/usr/local/var/mysql/your-pc-name.lan.pid).

Here’s a quick way to fix it:

Check the ownership if /usr/local/var/mysql/. If it is not owned by mysql user, then simply make it owned by mysql with the following command:

sudo chown -R mysql /usr/local/var/mysql/

Then start the service once more.

sudo mysql.server start

That’s all!

Reference

1. MySql server startup error ‘The server quit without updating PID file’ – Stack Overflow. http://stackoverflow.com/questions/4963171/mysql-server-startup-error-the-server-quit-without-updating-pid-file [4/3/2017].