authentication plugin caching_sha2_password cannot be loaded ：

MYSQL命令

1. mysqld -install 注册服务  
2. net start mysql 启动服务  
3. mysql -h localhost -uroot -p 密码登陆
4. alter user 'root'@'localhost'IDENTIFIED BY 'MyNewPass';
5. FLUSH PRIVILEGES;

 

authentication plugin caching_sha2_password cannot be loaded ：

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

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> FLUSH PRIVILEGES;