MySQL authentication plugin 'caching_sha2_password' cannot be loaded 問題
MySQL版本是 8.0.13
在使用Navicat時連結資料庫出現上述問題：authentication plugin 'caching_sha2_password' cannot be loaded，所以認為是外掛問題。
1、修改外掛 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'archiver';
2、此時產生一個問題，MySQL的登入密碼會出錯，所以重新修改密碼
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新的密碼';
3、flush privileges;
問題解決！
相關文章
- 遠端連線MySQL錯誤“plugin caching_sha2_password could not be loaded”的解決辦法MySqlPlugin
- MGR無法連線主節點Authentication plugin 'caching_sha2_password'Plugin
- MySQL8.0的caching_sha2_password問題MySql
- SQLyog連線資料庫報錯：錯誤號碼2058 plugin caching_sha2_password could not be loadedSQL資料庫Plugin
- authentication plugin caching_sha2Plugin
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- 問題排查之RocketMQAutoConfiguration not loaded.MQ
- Memory Notification: Library Cache Object loaded into SGA問題Object
- 【scala】問題cannot resolve symbol sparkSymbolSpark
- 500 OOPS: cannot change directory問題OOP
- 關於 Ident authentication failed for user "postgres" 的問題IDEAI
- 【問題處理】Memory Notification: Library Cache Object loaded into SGAObject
- Taglist: Exuberant ctags (http://ctags.sf.net) not found in PATH. Plugin is not loaded.HTTPPlugin
- Jquery DataTables解決 Cannot reinitialise DataTable 問題jQuery
- Cannot access a disposed object.問題根源所在.....Object
- MySQL Rewriter Query Rewrite PluginMySqlPlugin
- TypeError: Descriptors cannot not be created directly問題的解決Error
- 使用eclipse執行maven-release-plugin外掛釋出jar異常問題（.project）(Cannot prepare the release because you have local modifications )EclipseMavenPluginJARProject
- MySQL 問題MySql
- 解決Vagrant報錯Warning: Authentication failure. Retrying問題AI
- cannot read prpperty ‘start‘ of undefined（問題記錄）Undefined
- Cannot connect on socket(25)_NetBackup 問題解決
- android studio Cannot reload AVD list問題Android
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- MySQL 除法問題MySql
- MySQL range問題MySql
- Authentication failure 以及xxx is not in the sudoers file 問題的解決辦法AI
- MYSQL(解決方法):Client does not support authentication(轉)MySqlclient
- 【問題解決】property [elasticsearch.version] is missing for plugin [head]ElasticsearchPlugin
- MySQL 8 新特性之Clone PluginMySqlPlugin
- 解決Maven外掛無法下載Cannot resolve plugin org.apache.maven.plugins:maven-clean-plugin:2.5MavenPluginApache
- TSM備份時提示認證失敗(Authentication failure)問題的解決AI
- mysql-proxy does not work with server/client authentication pluginsMySqlServerclientPlugin
- 記錄一次postcss-plugin-px2rem失效問題CSSPluginREM
- vue預渲染prerender-spa-plugin解決首屏白屏問題VuePlugin
- mysql 轉義問題MySql
- MySQL死鎖問題MySql
- MySQL行號問題MySql