我正在尝试通过phpmyadmin中的SQL选项卡创建/导入一个如下所示的视图:
CREATE ALGORITHM=UNDEFINED DEFINER=`byname`@`localhost` SQL SECURITY DEFINER VIEW `wr_averages` AS select `nf_users`.`id` AS `id`,(`nf_users`.`points` / `nf_users`.`played`) AS `average_points` from `nf_users` where (`nf_users`.`played` > 24);
我遇到了这个错误:
#1227 - Access denied; you need the SUPER privilege for this operation
我在我的托管公司无法获得SUPER权限,那么有什么方法可以解决这个问题吗?
提前感谢 :-)
username@localhost
,而应该是username@%
。 - Marco Marsala