Fix Public Key Retrieval Is Not Allowed MYSQL DBeaver

By Aliif Arief · 1 minute

This error occurs when you try to connect to a MySQL database using DBeaver. The error message is “Public Key Retrieval is not allowed”. This error is caused by the default setting of the MySQL server. In this article, I will show you how to fix this error.

Solution

https://stackoverflow.com/a/59778108/14854568

or maybe just add allowPublicKeyRetrieval=true to the connection string.

jdbc:mysql://localhost:3306/dbname?allowPublicKeyRetrieval=true

----