1.打开mysql8.0DOS命令框
2.输入mysql密码(这里如果是升级到mysql8.0的用户输入之前的密码即可)
3.依次执行下面的命令 。第二条 ‘ ’中的内容即为新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
#更新一下用户的密码
4. 刷新权限并重置密码
再重置下密码:alter user 'root'@'localhost' identified by '123456';