Aikesheng Open Source Community

Sep 8, 2022 · Databases

Troubleshooting MySQL Remote Connection Failure Caused by skip-grants-tables

This article describes a step‑by‑step investigation of a MySQL remote‑connection failure where the server reports port 0, explains how the skip‑grants‑tables option implicitly enables skip‑networking, and provides the simple fix of commenting out the option and restarting the service.