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:

Can you give the o/p of select user,host,password from mysql.user where user='root'; — DBHash.com, Aug 16 '15 at 14:09

score 7 · Accepted Answer · answered Aug 10 '15 at 07:47

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

score 3 · Answer 2 · edited May 23 '17 at 11:43

3

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.

edited May 23 '17 at 11:43

Community

1
1

answered Aug 06 '15 at 10:07

CM.

1,007
1
7
19

1

I updated my question what happens on my end. I tried to set the password to "" – matt Aug 06 '15 at 10:15
1

so you are able to access the database now. – CM. Aug 06 '15 at 10:19
1

no, I'm not unfortunately, see my update in the question. – matt Aug 06 '15 at 14:39
1

@matt have you tried setting the password a nonempty string? What happens? – CM. Aug 06 '15 at 18:41

score 2 · Answer 3 · answered Aug 10 '15 at 13:47

"No" password and password = '' are different things.

For "no" password:

mysql -u root

For '':

mysql -u root -p

and then enter empty line when prompted

mysql -u root -p root

with a space between -p and root means: (1) prompt for password, then (2) USE root to establish the default database.

mysql -u root -proot

without a space says "my password is 'root'".

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

3 Answers3