今天把数据库用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重新创建,问题解决!