MySQL：vicat Premium 12连接MySQL数据库出现Authentication plugin ‘caching_sha2_password‘ cannot be loaded

缺乏、安全感 2023-08-17 15:22 111阅读 0赞

# 错误 #

*  很多用户在使用Navicat Premium 12连接MySQL数据库时会出现Authentication plugin ‘caching\_sha2\_password’ cannot be loaded的错误，

# 解决 #

1.  管理员权限运行命令提示符，登陆MySQL
    
        mysql -u root -p
        
        password                                                                         #登入mysql
    
    ![在这里插入图片描述][20190926093701762.png]
2.  修改账户密码加密规则并更新用户密码
    
        ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;   #修改加密规则 
        
        
        ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';   #更新一下用户的密码
    
    ![在这里插入图片描述][20190926093728904.png]
3.  刷新权限并重置密码
    
        FLUSH PRIVILEGES;   #刷新权限
    
    ![在这里插入图片描述][20190926093749754.png]
    
    再重置下密码：
    
        alter user 'root'@'localhost' identified by '111111';
    
    ![在这里插入图片描述][20190926093813910.png]

[20190926093701762.png]: /images/20230810/e29eb21892ce4fe2b00873cc698ca16e.png
[20190926093728904.png]: /images/20230810/63dcdc7089ae44b9bb0494fa7baa8fee.png
[20190926093749754.png]: /images/20230810/7cda886b00fd4c1b966c34e4967d92e1.png
[20190926093813910.png]: /images/20230810/f52fceab5fe0413082b5e1e0b469b30b.png