标题: Access denied; you need the SUPER privilege for this operation报错解决方法 [打印本页] 作者: admin 时间: 2020-4-21 17:22 标题: Access denied; you need the SUPER privilege for this operation报错解决方法 Access denied; you need the SUPER privilege for this operation报错解决方法
#1227 - Access denied; you need the SUPER privilege for this operation
出问题的sql代码：
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`)));