Troubleshoot MySQL ERROR 1045 under Mac (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Maybe updating the package the Updater overwrote the root password.

To restore it:

Stop mysqld deamons.

$ sudo service mysqld stop

Go to Mysql/bin Directory

$ cd /usr/bin

Start a MySQL deamon with this option:

$ sudo mysqld_safe --skip-grant-tables

Open another terminal and open a MySQL session to execute this:

$ mysqlmysql> use mysql;see Note1 below for next line.mysql> UPDATE user SET authentication_string=PASSWORD(‘YOUR_NEW_PASSWORD_HERE‘) WHERE user = ‘root‘;mysql> exit;

Now kill the Mysqld_safe process and restart Mysqld normally:

$ sudo service mysqld start

Note1: password is the column name in table mysql.user prior to version 5.7. After which it became authentication_string . Change your UPDATE statement accordingly.

How you can not understand, give me a message, I teach you.

Troubleshoot MySQL ERROR 1045 under Mac (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)