Mac first install MySQL 5.7.12 do not know the root password solution

For 2 nights, this has to be a record.

1. First stop MySQL from System Preferences

2. Open the Mac command-line tool, sudo su runs the command as an administrator

3. Cd/usr/local/mysql/bin (MySQL installation directory)

4../mysqld_safe --skip-grant-tables &

5. Mysql-p

mysql>  update mysql. 6 user . set authentication_string= password ( ‘123qwe‘ )  where user = ‘root‘ andHost = ‘localhost‘;

7.flush privileges;

After all the above steps and then from the Workbench Basic 2 times the password can be connected

The 5th step is very important, because many people on the net to write the 5th step is to reset the password through workbench, I myself try to invalid, do not know whether the version of the problem

Mac first install MySQL 5.7.12 do not know the root password solution