Aikesheng Open Source Community

Mar 27, 2023 · Databases

Root Cause Analysis of MySQL sha256_password Deprecation Warning Triggered by Non‑existent Users

The article investigates why MySQL 8.0.27 repeatedly logs a deprecation warning for the sha256_password plugin, tracing the issue to authentication attempts with non‑existent users, analyzing source code, and proposing configuration and code‑level fixes.