Connection Java - MySQL : Public Key Retrieval is not allowed

Question

You should add client option to your mysql-connector allowPublicKeyRetrieval=true to allow the client to automatically request the public key from the server. Note that AllowPublicKeyRetrieval=True could allow a malicious proxy to perform a MITM attack to get the plaintext password, so it is False by default and must be explicitly enabled.

https://mysql-net.github.io/MySqlConnector/connection-options/

you could also try adding useSSL=false when you use it for testing/develop purposes

example:

jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false

For DBeaver users:

1. Right click your connection, choose "Edit Connection"

2. On the "Connection settings" screen (main screen) click on "Edit Driver Settings"

3. Click on "Connection properties"

4. Right click the "user properties" area and choose "Add new property"

5. Add two properties: "useSSL" and "allowPublicKeyRetrieval"

6. Set their values to "false" and "true" by double clicking on the "value" column

When doing this from DBeaver I had to go to "Connection settings" -> "SSL" tab and then :

• uncheck the "Verify server certificate"
• check the "Allow public key retrival"

This is how it looks like.

Note that this is suitable for local development only.

Use jdbc url as :

jdbc:mysql://localhost:3306/Database_dbName?allowPublicKeyRetrieval=true&useSSL=false;

PortNo: 3306 can be different in your configuation

Alternatively to the suggested answers you could try and use mysql_native_password authentication plugin instead of caching_sha2_password authentication plugin.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password_here'; 

I solve this issue using below configuration on spring boot framework

spring.datasource.url=jdbc:mysql://localhost:3306/db-name?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=root