日期:2014-05-16  浏览次数:20781 次

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