Mar 11, 2021 · Databases

Why MySQL “Public Key Retrieval is not allowed” Happens and How to Fix It

This article analyzes the intermittent “Public Key Retrieval is not allowed” error in MySQL 8.0 when using JDBC, C3P0, or Druid connections, explains the authentication plugins involved, and provides step‑by‑step configuration fixes and best‑practice recommendations.

AuthenticationC3P0Druid

0 likes · 8 min read

Why MySQL “Public Key Retrieval is not allowed” Happens and How to Fix It

Aikesheng Open Source Community

Mar 8, 2021 · Databases

Resolving Intermittent "Public Key Retrieval is not allowed" Errors in Java MySQL 8.0 JDBC Connections

This article explains why Java applications occasionally encounter the "Public Key Retrieval is not allowed" error when connecting to MySQL 8.0, analyzes the role of caching_sha2_password and user authentication cache, and provides practical solutions such as specifying the RSA public key, enabling AllowPublicKeyRetrieval=True, or switching to mysql_native_password.

DatabaseConnectionJDBCPublicKeyRetrieval

0 likes · 5 min read

Resolving Intermittent "Public Key Retrieval is not allowed" Errors in Java MySQL 8.0 JDBC Connections