MySQL import error ---- Cannot load from mysql. proc Solution

After upgrading mysql from mysql 5.1 to 5.5 in Linux, it is found that the stored procedure is unavailable. When you create and use a stored procedure, The system prompts "Cannot load from mysql. proc. The table is probably updated upted.

I checked the whole Baidu and confirmed the sentence "a huge copy of the article in the world!

This is almost the case in all articles.

The solution is very simple. Run the mysql_upgrade command. This command will generate a text file mysql_upgrade_info in the Data Directory, which contains the upgraded database version.

I don't know why, but it is not valid here. After the upgrade, various upgrades are OK, but this error is still reported.

Ask GOOGLE for help.

Http://bugs.mysql.com/bug.php? Id = 50183

The reason is that a field in mysql. proc is not successfully upgraded.

In mysql. proc 5.1, the comment field is varchar (64 ):

'Comment' char (64) character set utf8 COLLATE utf8_bin not null default '', but in 5.5 It should be text:

'Comment' text character set utf8 COLLATE utf8_bin not null,

So, execute the following statement and modify the field to text. Then, it is completely OK:

Alter table 'proc'

Modify column 'comment' text character set utf8 COLLATE utf8_bin not null after 'SQL _ mode ';