title: Permissions for creating a trigger in mysql
body: <p>mysql ver is 5.0.67 </p>
  
  <p>my trigger code is :</p>
  
  <pre><code>DELIMITER //
  CREATE TRIGGER upd_price BEFORE UPDATE ON product_price
   FOR EACH ROW BEGIN  
      INSERT INTO update_price_log (product_id, product_price_old, product_price_new) values(OLD.product_id, OLD.product_price, NEW.product_price);
  END
  //
  DELIMITER ;
  </code></pre>
  
  <p>error is:</p>
  
  <blockquote>
    <p>#1227 - Access denied; you need the SUPER privilege for this operation</p>
  </blockquote>
  
  <p>my server, is not cpanel!
  it is : DirectAdmin Web Control Panel. </p>
  
  <p>how can i create SUPER privilege and create my trigger?</p>