The user specified as a definer (”@’%') does not exist问题解决

问题原因

对应的sql创建用户不存在

解决方案

找到对应的视图函数，修改DEFINER后对应的用户即可，DEFINER=`root`@`%`

DROP FUNCTION IF EXISTS `getChildList`$$CREATE DEFINER=`root`@`%` FUNCTION `getChildList`(rootId TEXT) RETURNS TEXT CHARSET utf8BEGINDECLARE ptemp TEXT;DECLARE ctemp TEXT;SET ptemp = '#';SET ctemp = rootId;WHILE ctemp IS NOT NULL DOSET ptemp = CONCAT(ptemp, ',', ctemp);SELECT GROUP_CONCAT(id)INTO ctempFROM ac_orgWHERE FIND_IN_SET(pid, ctemp) > 0;END WHILE;RETURN ptemp;END$$DELIMITER ;