无法在Netbean中加载身份验证插件'caching_sha2_password' [英] Unable to load authentication plugin 'caching_sha2_password' in Netbean

问题描述

我正在将MySQL-8.0与Netbean连接起来并出现错误: 无法加载身份验证插件"caching_sha2_password". 有什么解决办法吗?

I am connecting MySQL - 8.0 with Netbean and get error: Unable to load authentication plugin 'caching_sha2_password'. Any solution for this ?

推荐答案

您应使用MySQL Connector/J 8.0.9或更高版本.

You should use MySQL Connector/J 8.0.9 or higher.

对于Windows 7:

For Windows 7:

1. 创建新驱动程序创建新驱动程序
2. 选择一个新的MySQL Connector/J 8.0.9或更高版本选择新的驱动程序如果您不是在MySQL安装过程中安装的，则应该先安装
3. 使用新驱动程序创建新连接新连接创建
4. 检查信息，输入密码，将"zeroDateTimeBehavior"参数的值更改为"CONVERT_TO_NULL"，测试连接检查连接如果出现时区"错误，则应首先配置MySQL时区

1. Create a new driver new driver creation
2. Select a new MySQL Connector/J 8.0.9 or higher choosing new driver If you didn't install it during MySQL setup, you should do it first
3. Create a new connection using new driver new connection creation
4. Check an information, enter the password, change a value of the "zeroDateTimeBehavior" param to "CONVERT_TO_NULL", test the connection check connection If you have a "time zone" error, you should configure your MySQL time zone first

这篇关于无法在Netbean中加载身份验证插件'caching_sha2_password'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！