mysql on osx: access denied and can't connect to socket

Question

I can't seem to figure out what I have to do in order to install/setup mysql correctly on my new mac.

1.) I installend mysql via homebrew

2.) I'm able to run mysql.server start

3.) If I try to run mysql -u root -p I get this

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

I googled and looked through all kind of sources, but can't seem to figure out what to do.

---

Update:

Update 2:

Answer 1

Let's stop mysqld:

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Clean re-installation procedure:

brew remove mysql
brew cleanup
brew doctor

Backup your database before do next step. Then clean data directory up (to avoid manual run extra step mysql_install_db later):

sudo rm -rf /usr/local/var/mysql

The latest step is to install it again from scratch:

brew update
brew install mysql

Then run mysqld and try to login to CLI:

launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
mysql -u root

Answer 2

On the 3rd step run it without -p option, which stands for password requirement: Run the command like this mysql -u root. If you need to set a password there is another post about it here.