BestHub
Sign in
Tagged articles

caching_sha2_password

5 articles · Page 1 of 1
java1234
java1234
Sep 29, 2026 · Databases

MySQL 9.7 Explored: Vector Search, JavaScript Stored Procedures & Bulk Import Gains

This article explores MySQL 9.7's key innovations including native VECTOR type for semantic search, JavaScript stored procedures for in-database logic, parallel bulk import from object storage, and security upgrades like mandatory caching_sha2_password, with practical code examples and upgrade guidance.

Innovation releaseJavaScript stored proceduresMySQL 9.7
0 likes · 18 min read
MySQL 9.7 Explored: Vector Search, JavaScript Stored Procedures & Bulk Import Gains
DeWu Technology
DeWu Technology
Oct 1, 2021 · Databases

MySQL 8.0 New Authentication Plugin: caching_sha2_password

MySQL 8.0 replaces the default mysql_native_password with the caching_sha2_password plugin, which stores a 70‑byte salted SHA‑256 hash with configurable rounds, caches SHA256(password) for fast logins, and falls back to RSA‑encrypted full verification on insecure connections, supporting user creation, replication and key management.

AuthenticationMySQLRSA
0 likes · 14 min read
MySQL 8.0 New Authentication Plugin: caching_sha2_password
Aikesheng Open Source Community
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.

DatabaseConnectionJDBCMySQL
0 likes · 5 min read
Resolving Intermittent "Public Key Retrieval is not allowed" Errors in Java MySQL 8.0 JDBC Connections