title: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
body: <p>So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G</p>
  
  <p>mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db &lt; db.sql</p>
  
  <p>It got stuck at:</p>
  
  <pre><code>ERROR 1227 (42000) at line 374: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  </code></pre>
  
  <p>The actual sql content is:</p>
  
  <pre><code>/*!50003 CREATE*/ /*!50017 DEFINER=`another_user`@`1.2.3.4`*/ /*!50003 TRIGGER `change_log_BINS` BEFORE INSERT ON `change_log` FOR EACH ROW
  IF (NEW.created_at IS NULL OR NEW.created_at = '00-00-00 00:00:00' OR NEW.created_at = '') THEN
          SET NEW.created_at = NOW();
  END IF */;;
  </code></pre>
  
  <p><code>another_user</code> is not existed in rds, so I do:</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON db.* TO another_user@'localhost';
  </code></pre>
  
  <p>Still no luck.</p>