Mac MySQL connection error error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

For half a day.

Kill process again, change the settings file, and restart the computer, it will not work

Turn to the solution on StackOverflow and implement success:

Original link: https://stackoverflow.com/questions/13480170/access-denied-for-mysql-error-1045

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 password=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.

There are pits please note:

1. The first sentence "sudo service mysqld stop” 我电脑提示service: command not found，但是不执行这句好像也没什么关系

2.Note section, password keyword in the new version has been modified to authentication_string

Thanksgiving author.

Mac MySQL connection error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)