sudo chown -R mysql /usr/local/var/mysql/ <- mysql wouldn't work for me until I ran this command.

Tells you when it finishes (my install took 10 minutes)

sudo brew install mysql -with-embedded say done <- Installs mysql with the embedded server.

it gives you some idea of what's coming next

sudo brew info mysql <- skim through this.

sudo brew install openssl <- dependency for mysql, useful.

sudo brew install cmake <- dependency for mysql, useful.

Edit 2018: you can't run brew as root anymore I like to run brew as root, but I don't think you have to. Do remove stuff in its own mysql directory.

For example, don't delete stuff in a PHP install's directory. Note that many programs have drivers for mysql which you do not want to remove.

Using your judgement, rm -rf these files.

ps -ef | grep mysql <- lists processes with mysql in their name.

rver stop <- may need editing based on your version.

Mysql should now work and be running all the time as expected Run the commands Brew suggests, add MySQL to launchctl so it automatically launches at startup Unset TMPDIR mysql_install_db -verbose -user=`whoami` -basedir='$(brew -prefix mysql)' -datadir=/usr/local/var/mysql -tmpdir=/tmp # whoami is executed inline

sudo rm -rf /private/var/db/receipts/*mysql*īrew install MySQL per user Sedorner from this StackOverflow answer.

edit /etc/hostconfig and remove the line MYSQLCOM=-YES.

launchctl unload -w ~/Library/LaunchAgents/.

sudo rm -rf /Library/PreferencePanes/My*.

sudo rm -rf /Library/StartupItems/MySQLCOM.

Here are detailed instructions combining getting rid of all MySQL from your Mac then installing it The Brew Way as Sedorner wrote above: Remove MySQL completely per The Tech Lab Note the second: a commenter says step 2 is not required. Note: the -force bit on brew cleanup will also cleanup outdated kegs, think it's a new-ish homebrew feature. Launchctl load -w ~/Library/LaunchAgents/ Used the alternate security script: /usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installationįollowed the launchctl section from the brew package script output such as, #start Start mysql with rver start command, to be able to log on it Mysql_install_db -verbose -user=`whoami` -basedir='$(brew -prefix mysql)' -datadir=/usr/local/var/mysql -tmpdir=/tmp Ran the commands brew suggested: (see note: below) unset TMPDIR

installed mysql with brew install mysql.

Launchctl unload -w ~/Library/LaunchAgents/ Note also your alternate security script directory will be based on which version of MySQL you are installing. Used brew's remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf (leave that one up to you, should it apply) and launchctl plist I had the same problem and none of the above solutions worked for me. I think one can end up in this position with older versions of mysql already installed.

Install mysql on mac brew