Friday, March 25, 2011

MySQL 5.5.10 homebrew install issue

Coming after the mysql 5.1.52 homebrew install issue, the just released mysql 5.5.10, which solved the previous problem, has another issue.

When starting mysql daemon with mysql.server script, it showed error message like
ERROR! The server quit without updating PID file (/usr/local/var/mysql/data/*********.pid).
The new homebrew instruction to install mysql makes its default $datadir to be $basedir/data but the setting of $datadir in mysql.server line 70 didn't be fixed to corresponded to the change.

Adjust $datadir in script or just use boot parameter --data-dir=/usr/local/Cellar/mysql/5.5.10/data/ makes mysql.server work.

1 comment:

Krzysztof Szafranek said...

I just wasted some time trying to figure it out and your post had just the right solution. Thank you!