在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 .
问题解决!可以建存储过程了.