[Solved] cannot load from mysql.proc. the table is probably corrupted

Execute the following command: mysql_ Upgrade - U root - P password

Since the versions of MySQL 5.5 and above, the column attribute of comment field in the proc table of MySQL database has been changed from char (64) to text type

The following data types need to be changed for versions of mysql5.5 and above:

ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;

Similar Posts: