In theory mysql_upgrade
should do the trick but sometime it fails some step ‘silently’. Then when doing backup you will have this :
Cannot load from mysql.proc. The table is probably corrupted
Gasp. Don’t panic, this is a very simple error to fix. Just change the type of the ‘comment’ column :
alter table proc change comment comment text;