Connection between DBeaver & MySQL

Question

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 ?

can elaborate what you have done so far started a new connection in dbeaver and add ssl support and added your crt file in the appropriate textbox and then comes the error? — nbk, May 14 '20 at 20:27
I solved this problem with below settings [enter image description here](https://i.stack.imgur.com/BMBl6.jpg) — dungvt, Apr 04 '21 at 04:19

score 91 · Answer 1 · edited Jan 28 '23 at 13:08

91

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 respectively by double clicking on the value column
Save and test the connection.

Hopefully it should work!

edited Jan 28 '23 at 13:08

Manuel Jordan

15,253
21
95
158

answered May 21 '20 at 17:02

Ratish Bansal

1,982
1
10
19

1

It gives me an error said: Access denied for user 'root'@'localhost' (using password: YES) after trying your answer. – Gloria Chen Mar 19 '21 at 05:13
It works through the `Drivers properties` tab. – Manuel Jordan Mar 29 '21 at 19:09
You're awesome! – Vitor Kevin Jan 04 '22 at 20:42
The interface has changed in 21.3.5. The `edit connection` context menu item now opens a MySQL dialog. In this dialog the three referenced items are not *user properties* any longer. They're in the main list of driver properties. So, you just have to find them in the list and adjust accordingly. – naugiedoggie Feb 27 '22 at 01:30
You also get it using `useSSL=true` either. – Fábio Filho Apr 06 '22 at 15:02
I was able to use this solution over the accepted to avoid having to specify certificates needed for SSL :) – Funsaized Jul 31 '22 at 19:05

score 33 · Answer 2 · edited Jan 28 '23 at 13:09

33

Edit Connection

click second tab Driver Properties

Change property allowPublicKeyRetrieval to True

Connection settings or Driver properties:

edited Jan 28 '23 at 13:09

Manuel Jordan

15,253
21
95
158

answered Mar 08 '21 at 18:00

OxaCyber

431
5
3

score 15 · Accepted Answer · answered May 16 '20 at 06:37

15

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"

answered May 16 '20 at 06:37

Carlos Robles

10,828
3
41
60

score 2 · Answer 4 · answered Jun 02 '20 at 22:31

2

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:

answered Jun 02 '20 at 22:31

agm1984

15,500
6
89
113

Connection between DBeaver & MySQL

4 Answers4