How to solve the problem of forgetting the root password of Mysql on Mac

I haven't used mysql on my computer for a long time and I have forgotten my password. But it doesn't matter, we can reset our password

The principle is to open the MySQL service in a safe way and then update the table storing the password.

First we need to shut down the original MySQL service, System Preferences->MySQL->Stop MySQL Server

Then open a Terminal, open mysql in safe mode, and no password is required when connecting

sudo mysqld_safe --skip-grant-tables

Then open another Terminal and update the password

mysql -u root
UPDATE mysql.user SET authentication_string=PASSWORD('your_new_password') WHERE User='root';
FLUSH PRIVILEGES;

In the above format, you only need to modify your_new_password

If the Mysql version is before V5.7.9, please use the following sql statement

UPDATE mysql.user SET Password=PASSWORD('your_new_password') WHERE User='root';

Finally restart Mysql and give it a try

mysql -uroot -pyour_new_password

Mission accomplished! ! ! !

In addition, here is the solution provided by netizens:

step1:

Shut down the MySQL service: Apple->System Preferences->Click MySQL at the bottom. In the pop-up page, shut down the MySQL service (click Stop MySQL Server).

step2:

Enter the terminal and type: cd /usr/local/mysql/bin/
After pressing Enter, log in with administrator privileges sudo su
After pressing Enter, enter the following command to disable the mysql authentication function./mysqld_safe ./mysqld_safe --skip-grant-tables &
After pressing Enter, MySQL will automatically restart (the status of MySQL in the preferences will become running)

step3:

Enter the command ./mysql
After pressing Enter, enter the command FLUSH PRIVILEGES;
After pressing Enter, enter the command SET PASSWORD FOR 'root'@'localhost' = PASSWORD('你的新密碼');

After completing the above steps, the password has been changed successfully. Now you can use the newly set password to log in to MySQL.