Aikesheng Open Source Community

Aug 17, 2022 · Databases

Unexpected Default User in MySQL Client: Investigation and Resolution

The article investigates why the MySQL client defaults to a non‑root user (zhenxing) despite configuration files showing root, detailing the discovery of the hidden .mylogin.cnf file, the effect of --no-defaults, and how MySQL reads option files in a specific order.