title: why can't I import a mysql dump with triggers into mariadb
body: <p>We plan to migrate our stuff into swisscom app cloud and therefore need to import existing MySQL dumps into MariaDB - so far no big deal...</p>
  
  <p>But the import of the dumps fail as soon as a trigger should be imported.</p>
  
  <p>e.g. I have a dump with this single trigger: </p>
  
  <pre><code>DELIMITER ;;
  /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trg_mytable_insert AFTER INSERT ON mytable FOR EACH ROW
                      BEGIN
  
                           INSERT INTO mytable_audit (id, fk_X)
                           SELECT a.id, a.fk_X FROM mytable a WHERE a.id = NEW.id;
  
                      END */;;
  DELIMITER ;
  </code></pre>
  
  <p>I trigger the import like this:</p>
  
  <pre><code>mysql --user xxxxxxx -pxxxxxxx -h 127.0.0.1 -P 13000 CF_E7D2D18F_A20B_4FFF_89A7_XXXXXXXX &lt; trigger.sql
  </code></pre>
  
  <p>causes this error:</p>
  
  <pre><code>ERROR 1227 (42000) at line 2: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  </code></pre>
  
  <p>The strange thing is, that with liquibase we are able to create triggers with the exact same user. So what special privileges are required to import a trigger via <code>mysql</code> CLI?</p>