ssl connection working in MySQL Workbench, but not in DBeaver

Question

I am getting an 'access denied' error trying to connect to a Google Cloud SQL MySQL instance with ssl in DBeaver.

I am able to

• connect to the server with the same ssl credentials in MySQL Workbench
• connect without ssl credentials (through user name / password) in DBeaver.

Any suggestions why this might be?

Solution 1

You can add connection with SSL support, at least in latest version for today (5.1). Create connection as usual, then skip testing and go to next step, then on SSL tab select "Require SSL" and unselect other checkboxes if selected, then test the connection.

Solution 2

in dbeaver the ssl connection configuration is available but it is not working and it is not implemented, it took me a day to find out that this is because of dbeaver bug. If you need to connect through ssl to Postgres, you can use 'DataGrip' instead. As mentioned here: https://dbeaver.io/forum/viewtopic.php?f=2&t=1921 'Currently DBeaver doesn't support SSL connections out of the box. You could try to configure it manually if you are familiar with Java (instructions are at https://jdbc.postgresql.org/documentati ... lient.html).

Easy SSL support is in TODO and will be added in one of next versions.'

Comments

[oulenz]

Yes it was a bug in DBeaver which got fixed