How to install MySQL on Mavericks / Mac (10.9.2)?

Question

I spent all night to get mysql to work on my Mac. I am stuck in the following loop:

iMAC:~ admin$ brew install mysql
Warning: mysql-5.6.16 already installed

iMAC:~ admin$ mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/iMAC.local.pid).

iMAC:~ admin$ mysql.server restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/iMAC.local.pid).

iMAC:~ admin$ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
homebrew.mxcl.mysql: Already loaded

iMAC:~ admin$ brew uninstall mysql
Uninstalling /usr/local/Cellar/mysql/5.6.16...
Error: Permission denied - /usr/local/Cellar/mysql/5.6.16

iMAC:~ admin$ brew uninstall mysql --force
Uninstalling mysql...
Error: Permission denied - /usr/local/Cellar/mysql/5.6.16

Any tips on how to make it work?

Answer 1

These questions seem interconnected, and the answers there may help you:

• PID error when starting mysql.server?
• After installing MySQL via Brew, I get an error - the server shuts down without updating the PID file