## F&Q ## 一，客户端连接报：Unable to load authentication plugin 'caching_sha2_password'. Unable to load authentication plugin 'caching_sha2_password'. 高版本的mysql的密码使用sha2加密方式，低版本的客户端默认使用的native方式，需要修改身份验证机制； ### 1，登录Mysql ``` mysql -uxxxx -pxxxx ``` ### 2，查看当前验证机制 ``` use mysql select user,host,plugin,authentication_string from user; ```  ### 3，修改身份验证机制 ``` alter user 'root'@'localhost' identified with mysql_native_password by 'xxxxxx' ; alter user 'root'@'%' identified with mysql_native_password by 'xxxxxx' ; flush privileges; ``` ### 4，查看当前验证机制 ``` select user,host,plugin,authentication_string from user; ```