Recently, a new service requires the use of a MySQL 8 database. After installation, when connecting with the DBeaver client, an error occurs saying "Public Key Retrieval is not allowed".

Solution

Edit the connection - edit driver settings.

Switch to connection properties - right-click and add the following 2 new properties:

• allowPublicKeyRetrieval: true
• useSSL: false

Refer to the screenshot below:

Save and reconnect.

This article is partially referenced from: Connection Java - MySQL : Public Key Retrieval is not allowed