The user specified as a definer ('XXXXX'@'%') does not exist

是由于XXXXX用户对全局host无访问权限。因此只要给XXXXX用户添加一个访问权限即可

步奏如下：

mysql -u root -p passwd:　　mysql> grant all privileges on *.* to XXXXX@"%" identified by "Passwd";　　mysql> flush privileges;

搞定!