plugin caching sha2_password c
时间: 2023-09-30 08:01:58 浏览: 134
引用和提供了关于"plugin caching_sha2_password could not be loaded"错误的信息。这个错误通常是由于MySQL新版默认使用caching_sha2_password作为身份验证插件,而旧版则使用mysql_native_password。根据引用中的描述,报错可能是因为使用的sqlyog版本过旧,不支持新的身份验证插件。在这种情况下,可以尝试换回旧版插件来解决问题,方法是通过远程命令行登录mysql,并使用mysql -hlocalhost -uroot -proot -P3306命令。这样,问题应该就可以解决了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [SQLyog错误号码 plugin caching_sha2_password could not be loaded](https://blog.csdn.net/qq_54202620/article/details/122729704)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *2* [远程连接MySQL错误“plugin caching_sha2_password could not be loaded”的解决办法sql连接乱码](https://blog.csdn.net/liufeifeihuawei/article/details/129832339)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文