一直困扰我mysql建不了存储过程的问题终于解决了...

xiangzi21

在linux上安装的mysql5.1版本,想见个存储过程,而是总报错,提示如下.
 
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50033, now running 50142. Please use mysql_upgrade to fix this error.
 
上网查了很多原因也没找到,查信息表也会报这个同样的错误.
 

mysql> SELECT * FROM information_schame.ROUTINES;
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50033, now running 50142. Please use mysql_upgrade to fix this error.
 
最后根据提示在linux下执行了修复脚本 sh /usr/local/mysql/bin/mysql_upgrade_shell .
 
问题解决!可以建存储过程了.