Aikesheng Open Source Community

Sep 15, 2025 · Databases

Why SHOW GRANTS Misleads After Changing MySQL User Host and How to Fix It

This article explains why the SHOW GRANTS command can display permissions that differ from a MySQL user's actual abilities after modifying the host field, analyzes the underlying cause across multiple privilege tables, and provides safe methods—including RENAME USER—to resolve the inconsistency.