连接mysql8.0报错plugin caching_sha2_password could not be loaded

只需如下几步；

1.打开cmd 输入mysql -uroot -p 然后输入密码进入到mysql

2. ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;修改加密规则；

3. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; 更新密码；

4. FLUSH PRIVILEGES; 刷新

5. alter user 'root'@'localhost' identified by '123456'; 重新设置密码为123456

 

就这样  喵~