title: Create view without SUPER privileges in phpMyAdmin
body: <p>I am trying to via SQL tab within the phpmyadmin to create/import a view like this:</p>
  
  <pre><code>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` &gt; 24);
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>#1227 - Access denied; you need the SUPER privilege for this operation
  </code></pre>
  
  <p>I can not get SUPER privileges at my hosting company, so is there anyway to get around this?</p>
  
  <p>Thanks in advance :-)</p>