Fix ‘Cannot Load from mysql.proc’ in MySQL

Last updated: August 25, 2026.

The mysql.proc error normally means the server binaries and MySQL system tables belong to different releases. It often appears after an older MySQL installation was upgraded without completing the system-table upgrade.

Confirm the server version first

SELECT VERSION();
SELECT @@version_comment;

Back up every database before repairing system tables. Do not download a replacement mysql.proc table or create it manually; its definition is version-specific.

MySQL 5.7 and earlier

Use the mysql_upgrade program shipped with the same MySQL installation as the running server, then restart MySQL.

mysql_upgrade -u root -p --force

Review all output and resolve any table errors it reports. If multiple MySQL installations exist, verify which mysql_upgrade executable is being run.

MySQL 8.0

MySQL 8.0 performs server upgrades automatically and no longer uses mysql.proc. An application still querying that table needs to use supported metadata such as INFORMATION_SCHEMA.ROUTINES.

SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_SCHEMA = 'app_database';

MariaDB has a separate upgrade process and system-table layout; use the tools and documentation matching the actual server product. MySQL documents the checks performed by mysql_upgrade.