mysql升级报错

解决MySQL存储过程错误

最新推荐文章于 2024-05-20 09:45:04 发布

原创最新推荐文章于 2024-05-20 09:45:04 发布 · 249 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java

mysql 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了在使用MySQL过程中遇到的两个常见错误：列数不匹配及定义者用户不存在的问题，并提供了解决方案，包括升级MySQL、调整存储过程及触发器等。

uncategorized SQLException for SQL [insert into tuser...)]; SQL state [HY000];
error code [1558]; Column count of mysql.proc is wrong. Expected 20, found 16.
Created with MySQL 50095,
now running 50149.
Please use mysql_upgrade to fix this error.; nested exception is java.sql.SQLException: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50149. Please use mysql_upgrade to fix this error.

mysql_upgrade mysql -h 114.141.180.185 -uroot -pliuwanxiang

PreparedStatementCallback; uncategorized SQLException for SQL
[insert into tuser...)];
SQL state [HY000]; error code [1449]; The user specified as a definer (''@'') does not exist; nested exception is java.sql.SQLException:
The user specified as a definer (''@'') does not exist

show triggers；

删除trigger，重新建