1、用管理员打开cmd控制台窗口,输入
mysqld --shared-memory --skip-grant-tables;
2、重新用管理员打开一个窗口,输入mysql
3、首先刷新执行指令“FLUSH PRIVILEGES”,刷新权限:
4、更改密码
alert user ‘root’ @’localhost’ identified with mysql_native_password by ‘password’;
mysqld --shared-memory --skip-grant-tables;
alert user ‘root’ @’localhost’ identified with mysql_native_password by ‘password’;