Trouble installing MySQL on Mavericks with Homebrew

Perform these steps:

 $ killall mysqld $ sudo rm -rf /usr/local/Cellar/mysql $ sudo rm -rf /usr/local/opt/mysql $ sudo rm -rf /usr/local/var/mysql $ brew install mysql  $ launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist $ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist $ brew cleanup $ mysql -uroot

The following URL works for me:

http://blog.joefallon.net/2013/10/install-mysql-on-mac-osx-using-homebrew/

As you can see, the instruction is quite straightforward, and I just clean-installed Mavericks, so there is no pre-installed MySQL. I think that you got into the troubles probably because you homebrew remove before launchctl unload, so unloading and clean up might not be clearly done.

FYI, the following is the version numbers for my homebrew and the installed MySQL.

sh-3.2$ brew --version0.9.5sh-3.2$ mysql --versionmysql  Ver 14.14 Distrib 5.6.15, for osx10.9 (x86_64) using  EditLine wrappersh-3.2$ 

Any reason to insist of running it on MacOS without MAMP? My experience with MAMP is that it just runs out of the box with no effort. Also much easier to port to a new Mac for example.