[MySQL] Mac 啟動 MySQL 出現「ERROR! MySQL server PID file could not be found! ERROR! The server quit without updating PID file」

今天啟動MySQL服務時出現警告：

ERROR! MySQL server PID file could not be found!

ERROR! The server quit without updating PID file (/usr/local/mysql/data/XXX.pid).

回想一下因為更新brew更動到/usr/local/的目錄權限, 使用chown將目錄權限改回即可運作:

sudo chown _mysql /usr/local/var/mysql/*

Reference:

• After MySQL install via Brew, I get the error - The server quit without updating PID file