MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
来源:互联网 发布:淘宝试衣服软件 编辑:程序博客网 时间:2024/06/05 07:41
我在MySQL版本:Ver 14.14 Distrib 5.1.61上创建存储过程是没有问题的,但是在版本:Ver 14.12 Distrib 5.0.26上面创建存储过程的时候就出现了上面的错误。甚至使用show procedure status
查看存储过程都会报上面的错误。
错误原因:
是由于你曾经升级过mysql,或用不同的MySQL版本进行备份迁移恢复。升级和迁移完后未使用mysql_upgrade升级数据结构造成的。
mysql.proc:
是MySQL的系统表,用来记录存储过程或函数的信息。使用desc mysql.proc
查看上面不同版本的MySQL的mysql.proc,果然出错的MySQL的mysql.proc只有16列。
解决办法:
使用命令:mysql_upgrade -u[username] -p[password]
就可以解决。
查找MySQL的安装目录找到mysql_upgrade :
mysql_upgrade在MySQL的安装目录的bin中。可以使用如下命令查找MySQL的安装目录:ps -ef|grep -w mysql
,我获取的结果如下:
- 1
- 1
/usr/local/mysql 是指:mysql的安装路径。
/usr/local/mysql/bin 是指:mysql的运行程序存放路径,其中就包括 mysql_upgrade。
/usr/local/mysql/data 是指:mysql数据库文件的存放路径。
注意事项:
使用mysql_upgrade
对数据库的数据表结构等升级时,数据库引擎MyISAM 会做检查、修复的动作,InnoDB 执行 mysql_upgrade 没有作用。
参考文献
[1]Column count of mysql.proc is wrong. Expected 20, found 16
转载地址
- MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
- MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
- Error Number : 1547 Error Message: Column count of mysql.proc is wrong. Expected 20, found 16. The
- Column count of mysql.proc is wrong. Expected 20, found 16.解决方法
- Column count of mysql.proc is wrong. Expected 20, found 16.解决方法
- ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
- ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
- ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
- ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
- 执行mysql添加权限语法,报错提示:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. C
- mysql遇见 column count of mysql.proc is wrong expected 20 found16
- Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 5054
- mysql 1558 - Column count of mysql.proc is wrong 的解决
- System error:Column count of mysql.event is wrong.
- mysql新建root用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted
- mysql出现ERROR 1819 (HY000)的解决方法
- mysql 出现column not found 问题
- shell脚本编写彩色进度条
- 智能音乐搜索功能实现(二)
- Codeforces Round #384 (Div. 2) 743B Chloe and the sequence
- 实战:MySQL Sending data导致查询很慢的问题详细分析
- 网站开发注意事项下篇
- MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
- java之yield(),sleep(),wait()区别详解
- React Native中样式表中的一些样式属性
- 2017最新在linux上搭建hustOJ(ubuntu系统)
- 【Ex.】打印出菱形图案的简易方法
- 列表页 删除操作(单选/多选)
- ceph key的创建
- MySql官方建议:Innodb表最佳实践
- 清除select自带小三角