ERROR 1449 (HY000): The user specified as a definer ('db'@'%') does not exist

今天把数据库用Navicat导出sql重新导入后出现该问题

mysql  >  select * from ex_every_product;

ERROR 1449 (HY000): The user specified as a definer ('db'@'%') does not exist

检查sql文件发现:

CREATE ALGORITHM=UNDEFINED DEFINER='db'@'%` SQL SECURITY DEFINER VIEW `ex_every_product` AS select......................

应该改为:

CREATE VIEW `ex_every_product` AS select......................

原因是使用Navicat导出sql时创建视图语句出现问题,

删除该View重新创建,问题解决!