请选择 进入手机版 | 继续访问电脑版
Access denied; you need the SUPER privilege for this operation报错解决方法
#1227 - Access denied; you need the SUPER privilege for this operation
出问题的sql代码:
  1. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_web_product` AS select `web_product`.`Id` AS `Id`,`web_product`.`p_class` AS `p_class`,`web_product`.`p_code` AS `p_code`,`web_product`.`p_name` AS `p_name`,`web_product`.`p_symbol` AS `p_symbol`,`web_product`.`p_price` AS `p_price`,`web_product`.`p_price1` AS `p_price1`,`web_product`.`p_detail` AS `p_detail`,`web_product`.`p_createtime` AS `p_createtime`,`web_product`.`p_yhtitle` AS `p_yhtitle`,`web_product`.`p_pic` AS `p_pic`,`web_product`.`p_smallpic` AS `p_smallpic`,`web_product`.`p_size` AS `p_size`,`web_product`.`p_weight` AS `p_weight`,`web_product`.`p_face` AS `p_face`,`web_product`.`p_place` AS `p_place`,`web_product`.`p_producer` AS `p_producer`,`web_product`.`mn_id` AS `mn_id`,`web_product`.`p_pic1` AS `p_pic1`,`web_product`.`p_pic2` AS `p_pic2`,`web_product`.`p_pic3` AS `p_pic3`,`web_product`.`p_pic4` AS `p_pic4`,`web_product`.`p_pic5` AS `p_pic5`,`web_product_class`.`c_name` AS `c_name`,`web_product_class`.`c_code` AS `c_code`,`web_product_class`.`c_jianjie` AS `c_jianjie`,`web_product_class`.`c_img` AS `c_img`,`web_product_class`.`c_model` AS `c_model`,`web_product_class`.`c_enname` AS `c_enname` from (`web_product` join `web_product_class` on((`web_product`.`p_class` = `web_product_class`.`Id`)));
复制代码
解决方法:
DEFINER=`root`@`localhost`   删除即可
推荐给好友: [复制链接]
推荐文章
回复

使用道具 举报

发布主题
  • 今日更新:3
  • 昨日更新:0
  • 模板总数:8424
打造全国最大模板下载平台
技术维护在线

QQ:515138

周一至周日9:00-23:00

如有侵权请联系我们

515138@qq.com 在线QQ咨询

微信扫码关注我们

POWERED BY 模板下载 © 2020-2030 WWW.ZIDIU.COM( 粤ICP备17166275号 )