Search code examples
mysqldbeaver

Connection between DBeaver & MySQL


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 ?


Solution

  • 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"