晚上加班調用一個遠程拷貝的本地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

?

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