## 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; ```