#1227 - Access denied; you need the SUPER privilege for this operation 问题出在哪
我用province\city\area做省市县表名,建立视图view,用phpmyadmin无法上传,出现以下提示,哪位老师给提示下,问题出在哪呀
错误
SQL 查询:
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `view_area` AS SELECT `province`.`pid` AS `pid` , `province`.`pmc` AS `pmc` , `province`.`px` AS `px` , `city`.`cid` AS `cid` , `city`.`cmc` AS `cmc` , `city`.`cpx` AS `cpx` , `city`.`sspid` AS `sspid` , `area`.`aid` AS `aid` , `area`.`amc` AS `amc` , `area`.`apx` AS `apx` , `area`.`sscid` AS `sscid`
FROM (
(
`province`
JOIN `city`
)
JOIN `area`
)
WHERE (
(
`province`.`pid` = `city`.`sspid`
)
AND (
`city`.`cid` = `area`.`sscid`
)
);
MySQL 返回:
#1227 - Access denied; you need the SUPER privilege for this operation