title: Creating stored functions and triggers without SUPER privilege
body: <p>All I am trying to do is create some stored functions and triggers that act on some tables. I find that, for either of those, I get MySQL error #1419 (<code>You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)</code>). </p>
  
  <p><a href="https://i.stack.imgur.com/pZwnB.png" rel="noreferrer"><img src="https://i.stack.imgur.com/pZwnB.png" alt="Attempt with trigger"></a>I checked the <code>user</code> table of <code>mysql</code>, and find that my username is <code>HeadAdmin</code> and my hostname is <code>%</code>. I tried setting DEFINER as <code>HeadAdmin@%</code>, but it doesn't work. I go back to <code>user</code> table, try setting it that way (a <code>Super_priv</code> column exists), and it still doesn't work (it literally is an error to do so). </p>
  
  <p>I don't know how to use that <code>log_bin_trust_function_creators</code> variable, let alone <strong>why</strong> it's less safe. How can I create triggers and stored functions ? </p>