title: Can't create simple MySQL function without super privilege
body: <p>I've been creating stored procedures without problems but when trying to create a simple function which returns the result of a <code>COUNT()</code> function on a table, I get:</p>
  
  <blockquote>
    <p>ERROR 1418: This function has none of DETERMINISTIC, NO SQL, or READS
    SQL DATA in its declaration and binary logging is enabled (you <em>might</em>
    want to use the less safe log_bin_trust_function_creators variable)</p>
  </blockquote>
  
  <p>Since it's using <code>COUNT()</code> I change it to be <code>READS SQL DATA</code> but then get the error:</p>
  
  <blockquote>
    <p>ERROR 1419: 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>
  </blockquote>
  
  <p>I don't understand why I can create procedures but not functions. The logging is not something I really have access to, even if I understood what the problem was in that area... a little Googling suggests it's to do with DB replication or something but this is a simple DB only.</p>