mysql5.7 忘记密码

[mysqld] 下添加 skip-grant-tables

use mysql;

update mysql.user set authentication_string=password('6YzxUhntnm') where user='root';

flush privileges;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
1、 修改用户密码
alter user 'root'@'localhost' identified by 'jC*2eTgHF#l';  
或者
set password=password("69$84Rga.a");