3364
MySQLERRORCommonAccess ControlHIGH confidence
Access denied to system schema
Production Risk
Low — GRANT fails; no change occurs.
How to reproduce
trigger — this will error
trigger — this will error
GRANT SELECT ON information_schema.* TO 'user'@'localhost';
expected output
ERROR 3364 (HY000): Access to system schema 'information_schema' is rejected.
Fix
Grant performance_schema access correctly
Grant performance_schema access correctly
GRANT SELECT ON performance_schema.* TO 'user'@'localhost';
Why this works
performance_schema accepts standard GRANT SELECT; information_schema is always readable for the user's own data without a grant.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3364 ER_NO_SYSTEM_SCHEMA_ACCESS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev