Connexion between DBeaver & MySQL

Question

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 ?

Answer 1

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"
3. Click on "Connection properties"
4. Right click the "user properties" area and choose "Add new property"
5. Add two properties: "useSSL" and "allowPublicKeyRetrieval"
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!

Answer 2

Edit Connection

click second tab "Driver Properties"

Change property allowPublicKeyRetrieval = True

Connection settings/Driver properties:

Answer 3

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

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

Answer 4

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: