Connexion between DBeaver & MySQL
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!
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"