0
1.4K
ViewsConnexion between DBeaver & MySQL
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 ?
4 answers
Answer question0
Edit Connection
click second tab "Driver Properties"
Change property allowPublicKeyRetrieval = True
Connection settings/Driver properties:
0
Change the settings on Dbeaver:
- Right click your connection, choose "Edit Connection"
- On the "Connection settings" screen (main screen) click on "Edit
Driver Settings"
- Click on "Connection properties"
- Right click the "user properties" area and choose "Add new property"
- Add two properties: "useSSL" and "allowPublicKeyRetrieval"
- Set their values to "false" and "true" by double clicking on the "value" column
- Save and test the connection.
Hopefully it should work!
0
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"
0
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:
