关闭mysql服务
打开cmd 进入mysql/bin目录下,输入命令跳过密码验证
mysqld --console --skip-grant-tables --shared-memory
新打开一个cmd窗口,同样进入到mysql/bin目录下,依次输入下列命令
3.1 连接mysql
mysql
3.2选择user库
update mysql.user set authentication_string=("密码") where user="root";
flush privileges;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码';
flush privileges;
exit