MySQL does not start, always in the startup state to resolve "Mac OSX"

Recently, encountered a problem, that is, MAC using homebrew installed MySQL, today using Mysql.server Start,mysql can not start, restart can not find the PID, the service did not start!

The error is as follows:

Google, find a solution! Simple is: According to the error of the startup report, go to the appropriate folder, delete all the *.err files, and then create the no PID file!

It is possible to solve the problem at this point, but I still error, and then check whether there are MySQL related processes are running,

Run: ps-a |grep MySQL with the following results

Decisively kill all, re-run sudo mysql.server start, success! Later found that as long as there is no manual shutdown of the MySQL service, the computer into the sleep state, and then wake up, this problem will occur, so, the computer restarts a bit OK, the specific into the sleep state what happened, still did not ask for a solution!

MySQL does not start, always in the startup state to resolve "Mac OSX"