​

8.0改变了身份验证插件，改成使用老版本的身份验证插件方式就好了。

我的操作步骤:

1.修改C:\ProgramData\MySQL\MySQL Server 8.0\my.ini文件中,caching_sha2_password改为mysql_native_password


#default_authentication_plugin=caching_sha2_password default_authentication_plugin=mysql_native_password


2.修改mysql密码, 重启mysql服务就ok了.


cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"  C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p Enter password: *********  mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword'; Query OK, 0 rows affected (0.10 sec)  mysql> exit



========================================我是分割线==========================================

mysql8.0 Authentication plugin