title: Can't create MySQL trigger with TRIGGER privilege on 5.1.32
body: <p>My fellow developers and I have our own development schemas on a shared MySQL development database.  My assignment requires me to create triggers in my schema, yet I've been unsuccessful so far.</p>
  
  <pre><code>CREATE TRIGGER myTrigger AFTER DELETE on myTable
  FOR EACH ROW BEGIN
      -- DO STUFF
  END;
  </code></pre>
  
  <p>MySQL says:
  ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you <em>might</em> want to use the less safe log_bin_trust_function_creators variable)</p>
  
  <p>I checked the MySQL manual (<a href="http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html</a>):</p>
  
  <blockquote>
    <p>The TRIGGER privilege enables you to create and drop triggers. You must have this privilege for a table to create or drop triggers for that table. This privilege was added in MySQL 5.1.6. (Prior to MySQL 5.1.6, trigger operations required the SUPER privilege.) </p>
  </blockquote>
  
  <p>We are running "5.1.32-enterprise-gpl-advanced-log", so the TRIGGER privilege should be sufficient; however, the DBA granted me the TRIGGER privilege on <code>mySchema</code>.* and I can see it when I do SHOW GRANTS;, yet I still get this error about needing the "SUPER" privilege.  We don't want to give all of the developers SUPER.</p>
  
  <p>Any suggestions?</p>