1728
MySQLERRORCommonSystem TablesHIGH confidence
Cannot load from mysql system table; table may be corrupted
Production Risk
High — server functionality is impaired until system tables are repaired.
What this means
MySQL cannot read data from a required system table, typically due to corruption or an incompatible schema version.
Why it happens
- 1System table corruption.
- 2Incomplete mysql_upgrade after a version change.
- 3Manual modification of system table structure.
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs automatically during server startup or when accessing privileges.
expected output
ERROR 1728 (HY000): Cannot load from mysql.func. The table is probably corrupted.
Fix 1
Run mysql_upgrade to repair system tables
Run mysql_upgrade to repair system tables
mysql_upgrade -u root -p --force
Why this works
mysql_upgrade repairs and updates all system tables to match the current server version.
Fix 2
Restore from backup if corruption is severe
Restore from backup if corruption is severe
-- Restore from a known-good mysqldump of the mysql schema.
Why this works
A clean restore ensures system table integrity.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1728 ER_CANNOT_LOAD_FROM_TABLE_V2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev