For DBeaver users:
- Right-click your connection, choose "Edit Connection"
- On the "Connection settings" screen (main screen), click on "Edit Driver Settings"
- Click on "Driver properties"
- Set these two properties: "allowPublicKeyRetrieval" to true and "useSSL" to false