引起原因是创建视图用户名不存在,修改视图定义者,例如:DEFINER='@ '修改微DEFINER=`root`@`%`,
然后
ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vuser`
AS
SELECT * from user;引起原因是创建视图用户名不存在,修改视图定义者,例如:DEFINER='@ '修改微DEFINER=`root`@`%`,
然后
ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `vuser`
AS
SELECT * from user;