[Err] 1449 - The user specified as a definer ('admin_isbox'@'localhost') does not exist - TOMMYHU - 专注互联网开发及运营技术,提供相关资料及软件下载,奇趣网络时事评论!
Aug 21

[Err] 1449 - The user specified as a definer ('admin_isbox'@'localhost') does not exist 不指定

tommyhu , 07:57 , DBA » MYSQL , Comments(0) , Trackbacks(0) , Reads(2987) , Via Original Large | Medium | Small
晚上加班调用一个远程拷贝的本地Mysql的储存过程,报错:[Err] 1449 - The user specified as a definer ('admin_isbox'@'localhost') does not exist

凭借以前经常见到的root@localhost报错,给root赋值所有权限:

grant all privileges on *.* to root@"%" identified by ".";

flush privileges;

发现无效。

可能数据库没有此用户:

select user,host from mysql.user;

没找到此用户,但是报错出现了这个用户。寻求谷歌后,找到解决方法:

SELECT definer,type FROM mysql.proc GROUP BY definer,type;

UPDATE mysql.proc SET definer='root@localhost' WHERE definer = '*username*@localhost';

重启数据库,OK

ps:如果还报错,直接打开sql文件查找用户名替换好了
▲返回顶部

Add a comment

Nickname

emotemotemotemotemotemotemotemotemotemotemotemotemotemotemotemot