Aikesheng Open Source Community

May 28, 2024 · Databases

Root Cause Analysis of Unexpected read_only Setting in MySQL After Server Restart

This article details a step‑by‑step investigation of why a MySQL 8.0.25 server becomes read‑only after a patch‑induced restart, revealing that a persisted configuration in mysqld‑auto.cnf set by PERSIST_ONLY caused the discrepancy and how to verify and resolve it.