What should I do if I forget the initial password for installing mysql on mac?

What should I do if I forget the initial password for installing mysql on mac?

Forgetting the password is a headache. What should I do if I forget the initial password for installing mysql on mac? The specific solution is as follows:

Http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

Test method 3: The password is successfully reset.

(Thanks @ very much. Tell me there is a resetting method on the official website. I searched a bunch of resources online...
In addition, step 1 and Step 2 are quick solutions for Mysql forgetting the Root password or permission error on MAC

The English is not good, but the official team does not understand it too well ##)

Step 1:

Apple-> system preference settings-> at the bottom of the page, click mysql to close the mysql service on the pop-up page (Click stop mysql server)

Step 2:

Enter the terminal: cd/usr/local/mysql/bin/
Press enter and log on to the Administrator sudo su.
Press enter and enter the following command to disable mysql verification./mysqld_safe -- skip-grant-tables &
After you press enter, mysql will automatically restart (mysql in preference settings will change to running)

Step3.

Enter the command./mysql
Enter the command flush privileges;
Press enter and enter the command set password for 'root' @ 'localhost' = PASSWORD ('your new password ');

　　

At this point, the password has been changed and can be successfully logged on.

For more information about MySQL password operations, refer to the topic: MySQL password operations summary for learning.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.