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.
MySQLPERSIST_ONLYconfiguration
0 likes · 13 min read