title: MySQL/Amazon RDS error: "you do not have SUPER privileges..."
body: <p>I'm attempting to copy my mysql database from an Amazon EC2 to an RDS:</p>
  
  <p>I successfully did a <code>mysqldump</code> of my database into my root folder using this:</p>
  
  <pre><code>root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p &gt; my_database.sql
  </code></pre>
  
  <p>Then I tried to transfer this .sql file to my new RDS database:</p>
  
  <pre><code>root@ip-xx-xx-xx-xx:~# mysql my_database -u my_username -p -h  
  my_new_database.xxxxxxxxx.us-east-1.rds.amazonaws.com &lt; my_database.sql
  </code></pre>
  
  <p>Unfortunately, I get following error message:</p>
  
  <pre><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></pre>
  
  <p>I tried to <code>GRANT SUPER..</code> in a variety of ways but I'm getting errors when I try to do that too. Typing <code>mysql &gt; FLUSH privileges;</code> doesn't work either. </p>
  
  <p>I'm a mysql beginner so sorry for such an easy question. Thoughts?</p>