MySQL 1044 (42000): Access denied for user ' '@'localhost' to database 'mysql' with Mac

Question

I ran MySQL with the Terminal with the following command.

mysql -u root

Then I tried to execute use mysql;, but it did not go properly but showed an unexpected message as follows.

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Why do you think it's happening? Someone please help me..

score 1 · Answer 1 · edited May 23 '17 at 12:31

1

Your login credentials are wrong. Did you create a password while installing MySQL?

try mysql -u root -p and enter the password in the prompt to log in.

If you've lost your password, try resetting it. View this answer to reset password.

edited May 23 '17 at 12:31

Community

answered Nov 03 '15 at 18:21

Srinivas

Now I get error 1045. Can you tell me the next step? – MarshallLee Nov 03 '15 at 18:23
Did you try entering your password? – Srinivas Nov 03 '15 at 18:25
Reset your password and try. – Srinivas Nov 03 '15 at 18:29
@RicoAngeloni: If you find the answer useful, can you please upvote and mark as accepted answer? – Srinivas Nov 03 '15 at 18:30
Yes but I don't know how to reset the password.. Any suggestions please? – MarshallLee Nov 03 '15 at 18:30
@RicoAngeloni: check out these links [http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables] , [http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html] – Srinivas Nov 03 '15 at 18:32

1 Answers1