title: ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation - on AWS Lightsail Mysql DB
body: <p>I restored an AWS Lightsail DB (HA) from an emergency restore - and now I can't create functions or drop triggers, etc, when logged in as dbmasteruser - I receive this message: </p>
  
  <blockquote>
    <p>Error Code: 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've tried the console statement:  <code>SET GLOBAL log_bin_trust_function_creators = 1;</code> but get the access denied message.</p>
  
  <p>Has anybody seen this before and know how to fix it? Much obliged.</p>