brew install mysql on macOS

Question

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52.

Everything goes well and I am also successful with the mysql_install_db.
However when I try to connect to the server using:

/usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass' 

I get:

 /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at 'localhost'  failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I've tried to access mysqladmin or mysql using -u root -proot as well,
but it doesn't work with or without password.

This is a brand new installation on a brand new machine and as far as I know the new installation must be accessible without a root password. I also tried:

/usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installation 

but I also get

 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Answer 1

I think one can end up in this position with older versions of mysql already installed. I had the same problem and none of the above solutions worked for me. I fixed it thus:

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

Updated the string for the plist. Note also your alternate security script directory will be based on which version of MySQL you are installing.

Step-by-step:

brew remove mysql  brew cleanup  launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist  rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist  sudo rm -rf /usr/local/var/mysql 

I then started from scratch:

1. installed mysql with brew install mysql

2. ran the commands brew suggested: (see note: below)

   unset TMPDIR  mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp 

3. Start mysql with mysql.server start command, to be able to log on it

4. Used the alternate security script:

   /usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation 

5. Followed the launchctl section from the brew package script output such as,

   #start launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist  #stop launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist 

Note: the --force bit on brew cleanup will also cleanup outdated kegs, think it's a new-ish homebrew feature.

Note the second: a commenter says step 2 is not required. I don't want to test it, so YMMV!

Answer 2

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

• ps -ax | grep mysql
• stop and kill any MySQL processes
• sudo rm /usr/local/mysql
• sudo rm -rf /usr/local/var/mysql
• sudo rm -rf /usr/local/mysql*
• sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
• sudo rm -rf /Library/StartupItems/MySQLCOM
• sudo rm -rf /Library/PreferencePanes/My*
• launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
• edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
• rm -rf ~/Library/PreferencePanes/My*
• sudo rm -rf /Library/Receipts/mysql*
• sudo rm -rf /Library/Receipts/MySQL*
• sudo rm -rf /private/var/db/receipts/*mysql*
• sudo rm -rf /tmp/mysql*
• try to run mysql, it shouldn't work

---

Brew install MySQL per user Sedorner from this StackOverflow answer

• brew doctor and fix any errors

• brew remove mysql

• brew cleanup

• brew update

• brew install mysql

• unset TMPDIR

    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp # whoami is executed inline 

• mysql.server start

• run the commands Brew suggests, add MySQL to launchctl so it automatically launches at startup

mysql should now work and be running all the time as expected

Godspeed.