Aikesheng Open Source Community
Jul 19, 2023 · Databases
Understanding MySQL Permission Conflict Between USAGE and GRANT OPTION
This article explains why a MySQL user granted both USAGE and GRANT OPTION on a database can see schema information but cannot query table data, demonstrates the issue with local tests, and provides proper REVOKE commands to cleanly remove the conflicting permissions.
GRANT OPTIONMySQLPermissions
0 likes · 9 min read