mysql server 启动异常

启动异常原因：

.Logging to '/usr/local/mysql/data/xxx.local.err'.

local.err有问题，删掉。

在删之前，先杀掉
ps -ef | grep mysql
这个进程。

MySql server startup error 'The server quit without updating PID file '

https://stackoverflow.com/questions/4963171/mysql-server-startup-error-the-server-quit-without-updating-pid-file

try to find your log file with suffix ".err", there should be more info. It might be in:

/usr/local/var/mysql/your_computer_name.local.err

It's probably problem with permissions

check if any mysql instance is running

ps -ef | grep mysql

if yes, you should stop it, or kill the process

kill -9 PID

where PID is the number displayed next to username on output of previous command

&&&&&&&&& I got this case too on my mac, and just removed the error log, like '/usr/local/var/mysql/*.err', started successfully. – Mathew P. Jones Dec 2 '14 at 2:28