cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysql -uroot -p
(输入密码) 进入mysql执行下面三个命令
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '*******';
FLUSH PRIVILEGES;
server2012或2016下安装mysql
重装一遍mysql保留数据库
恢复正常
远程连接
修改用户root主机,local host改为%