3074
MySQLWARNINGCriticalSchemaHIGH confidence
INFORMATION_SCHEMA table was skipped
Production Risk
Low — query returns partial results; no data is lost.
What this means
An INFORMATION_SCHEMA query skipped a table because the table could not be opened or accessed, typically due to insufficient privileges or the table being locked.
Why it happens
- 1Insufficient privileges to access a referenced table.
- 2Table is locked or undergoing DDL when INFORMATION_SCHEMA is queried.
How to reproduce
trigger — this will error
trigger — this will error
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mydb';
expected output
Warning (Code 3074): INFORMATION_SCHEMA query skipped table 'mydb'.'lockedtable'.
Fix
Ensure the querying user has SELECT privilege on all target schemas
Ensure the querying user has SELECT privilege on all target schemas
GRANT SELECT ON mydb.* TO 'user'@'host';
Why this works
Grants the user access to the tables being listed.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3074 ER_WARN_I_S_SKIPPED_TABLE2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev