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
- SQLyog連線資料庫報錯:錯誤號碼2058 plugin caching_sha2_password could not be loadedSQL資料庫Plugin
- MySQL8.0的caching_sha2_password問題MySql
- authentication plugin caching_sha2Plugin
- 問題排查之RocketMQAutoConfiguration not loaded.MQ
- 【scala】問題cannot resolve symbol sparkSymbolSpark
- Taglist: Exuberant ctags (http://ctags.sf.net) not found in PATH. Plugin is not loaded.HTTPPlugin
- 關於 Ident authentication failed for user "postgres" 的問題IDEAI
- 遇到的cannot find module 'xxx' 問題
- virt-manager cannot open display問題
- Jquery DataTables解決 Cannot reinitialise DataTable 問題jQuery
- cannot read prpperty ‘start‘ of undefined(問題記錄)Undefined
- 高版本mysql訪問出現Client does not support authentication protocol requested by server;MySqlclientProtocolServer
- phpmyadmin mysql8 加密方式 caching_sha2_passwordPHPMySql加密
- Authentication failure 以及xxx is not in the sudoers file 問題的解決辦法AI
- TypeError: Descriptors cannot not be created directly問題的解決Error
- MySQL Rewriter Query Rewrite PluginMySqlPlugin
- MySQL 問題MySql
- 【問題解決】property [elasticsearch.version] is missing for plugin [head]ElasticsearchPlugin
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- 關於/usr/bin/ld: cannot find -lXX的問題
- 以MySQL為例,來看看maven-shade-plugin如何解決多版本驅動共存的問題?MySqlMavenPlugin
- mysql 1130 問題MySql
- 解決Maven外掛無法下載Cannot resolve plugin org.apache.maven.plugins:maven-clean-plugin:2.5MavenPluginApache
- 【問題處理】ORA-00376 file xx cannot be read at this time
- MySQL 8 新特性之Clone PluginMySqlPlugin
- 解決Mybatis連線Sql server 出現 Cannot load JDBC driver class 'com.mysql.jdbc.Driver '的問題MyBatisServerJDBCMySql
- JMeter連線mysql資料庫之connector包匹配問題(Cannot create PoolableConnectionFactory (Unknown initial character set index...)JMeterMySql資料庫Index
- mysql 轉義問題MySql
- mysql 遇到的問題MySql
- Mysql:常見問題MySql
- MySQL死鎖問題MySql
- Plugin 'org.apache.maven.plugins:maven-resources-plugin:2.7' not found less... (Ctrl+F1)問題解決PluginApacheMaven
- vue預渲染prerender-spa-plugin解決首屏白屏問題VuePlugin
- webpack4升級extract-text-webpack-plugin和UglifyJsPlugin問題WebPluginJS
- 記錄一次postcss-plugin-px2rem失效問題CSSPluginREM
- ] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin Cannot instantiate object of typeAIGoMyBatisMavenPluginObject