关于mysql存储过程报错The user specified as a definer ('oem'@'%') does not exist

查出有关用户

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

 

 

将没有的用户改成当前用户

 

 

UPDATE mysql.proc SET definer='root@%' WHERE definer = 'oem@%';