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

How to fix ERROR 1045 28000 - Access denied for user username@localhost using password- YES

Code2care@Mac % mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)

Let us break down the error codes first

1045: This is a MySQL-specific error code for authentication failure.

28000: This is a general SQLSTATE error code that indicates what was the cause of the authorization issue.

Cause of this issue:

The cause of this issue is self-explanatory by the error code 28000 message. You have provided incorrect login credentials to connect to the MySQL database.

Fix:

Username/Passwords are case sensitive. Make sure they are in the right case.
Make sure you have provided the correct username/password.
If the credentials are correct, make sure you are trying to connect to the right database (e.g. uat/staging/production)
Make sure the user/password has not expired.

If you are using the default installation, in most of cases, root user does not have a password. So when you try to connect to MySQL via the console, when prompted for a password, just press enter without inputting anything via the keyboard.

Have Questions? Post them here!

More Posts related to MySQL,

More Posts: