Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案

root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘password‘;

4、运行如下指令刷新密码，并更新密码

FLUSH PRIVILEGES; 
alter user ‘root‘@‘localhost‘ identified by ‘新密码‘;

5、再次连接就可以了

 

Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案

标签：连接mysql   inf   mic   color   解决   use   pass   flush   ever