DBeaver报错Unable to load authentication plugin 'caching_sha2_password'. Unable to load authentication

使用连接Mysql时报错 Unable to load authentication plugin 'caching_sha2_password'. 问题的原因大多说mysql的密码认证调整,

但其实DBeaver并不是只有一种Mysql的连接选项 切换至数据库选择页面 选择MySQL8+版本下载驱动,测试连接会提醒

Public Key Retrieval is not allowed.

DBeaver报错Unable to load authentication plugin 'caching_sha2_password'. Unable to load authentication

此时设置 驱动属性>allowPublicKeyRetrieval 设置为true即可

DBeaver报错Unable to load authentication plugin 'caching_sha2_password'. Unable to load authenticationDBeaver报错Unable to load authentication plugin 'caching_sha2_password'. Unable to load authentication