mysql8.0忘记密码

1.把/etc/my.conf 加多一行skip-grant-tables

2.update user set authentication_string='' where user = 'root';

3.quit;

4.把/etc/my.conf 删掉一行skip-grant-tables

5.再次免密码登录

6.alter user 'root'@'%' identified by 'abc123';

或者alter user 'root'@'localhost' identified by 'abc123';