Connexion between DBeaver & MySQL

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!


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"

Tags:

Mysql

Dbeaver