mysql5.7.22 above version forgot password when this modification

1. Turn off the MySQL service


2. Locate the MySQL installation path find  my.ini   open  under [mysqld]  add  skip-grant-tables  skip password check

3. Login to MySQL   mysql-uroot-proot (here root is the password, can also be entered freely)

4. Go to MySQL to change password
mysql> Update Mysql.user Set Authentication_string=password (' root ') where user= ' root ' and Host = ' localhost ';    123456 own New password * Special note is that there is no password field in the user table in the new MySQL database.
(if unsuccessful, repeat step 3
Log in to MySQL with Root: (here my account is root, the password is root)
Mysql-uroot-proot
Then change the password:
SET PASSWORD = PASSWORD (' root ');)

5. Remember to remove the skip-grant-tables from the My.ini  or anyone can log in to our database.

mysql5.7.22 above version forgot password when this modification