Connection between DBeaver & MySQL

user_11591931 0
Viewed 23540

I use DBeaver to watch an SQL database on MySQL 8+.

Everything is working, but sometimes, opening DBeaver, I have the following error message :

Public Key Retrieval is not allowed

And then, DBeaver can't connect to MySQL.

In order to fix this problem, I have to reconfigure MySQL.

Is there any simplest way to fix this problem ?

dbeaver mysql
4 Answers

Change the settings on Dbeaver:

  1. Right click your connection, choose "Edit Connection"
  2. On the "Connection settings" screen (main screen) click on "Edit Driver Settings" enter image description here
  3. Click on "Connection properties"
  4. Right click the "user properties" area and choose "Add new property"
  5. Add two properties: "useSSL" and "allowPublicKeyRetrieval" enter image description here
  6. Set their values to "false" and "true" by double clicking on the "value" column
  7. Save and test the connection.

Hopefully it should work!

user_108052300

Edit Connection

click second tab "Driver Properties"

Change property allowPublicKeyRetrieval = True

Connection settings/Driver properties:

enter image description here

user_66832410

Did you try explicitly allowing public key retrieval in DBeaver? In the connection settings, SSL tab you can find it

enter image description here

This is in case you are using SSL, otherwise in the same screen you can disable SSL by unchecking "use SSL" and "require SSL"

user_23574110

Ratish Bansal's solution works for me on MacOS Mojave, and after that, I always get a timezone error. The solution for that is to set my local timezone in the connection settings:

enter image description here

user_61410250
Related