What if I forget my MySQL password?

Local mysql I forgot the password , What do I do ？ Don't worry. Follow me step by step ：

1、 Apple -> System preferences -> Lowest point mysql  In the pop-up page   close mysql service ;

2、 Enter terminal input ：cd /usr/local/mysql/bin

3、 After returning Login administrator rights sudo su  （ Enter the password for your computer ）

4、 Enter the following command to disable mysql Verification function  ./mysqld_safe --skip-grant-tables &    （ Note that mysqld）

5、 After returning mysql It will restart automatically （ You can see in the preferences mysql The state of running）

6、 Then enter the command ./mysql

7、 After entering, you can see the following effect ：

There is a comforting mysql> Prompt ！！！

8、 The following is to change the password

Then the input ：FLUSH PRIVILEGES;

After returning , Input ：SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

Perfect password reset ！