mysql升级报错

最新推荐文章于 2023-02-26 16:03:58 发布

xsy_liuwanxiang

最新推荐文章于 2023-02-26 16:03:58 发布

阅读量237

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签：数据库 java

本文链接：https://blog.youkuaiyun.com/xsy_liuwanxiang/article/details/84355128

mysql 专栏收录该内容

6 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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，重新建