title: Unable to INSERT into an Amazon RDS database
body: <p>I setup my website on AWS.</p>
  
  <p>Now, the problem is: I am able to select data from my DB but <strong>I am not able to insert it</strong>. But, my root is having "Insert" privileges.</p>
  
  <p>I did create another user and provided the same privileges but the same problem persists.</p>
  
  <p>Here is my configuration:</p>
  
  <p><strong>mysql - "select" and "insert" privileges for "root" user.</strong></p>
  
  <pre><code>+-------------+-------------+
  | Select_priv | Insert_priv |
  | Y           | Y           |
  +-------------+-------------+
  </code></pre>
  
  <p><strong>mysql - "host" and "user" details</strong></p>
  
  <pre><code>+----------------+------+
  | host           | user |
  | %              | root |
  | 127.0.0.1      | root |
  | (my ip)        | root |
  | ::1            | root |
  | ip-(my ip)     |      |
  | ip-(my ip)     | root |
  | localhost      |      |
  | localhost      | root |
  +----------------+------+
  </code></pre>
  
  <p><strong>php</strong> - I am connecting using "username" as "root", "host" as "localhost" and "port" as 3306</p>
  
  <p><strong>Inbound security group</strong></p>
  
  <p><img src="https://i.stack.imgur.com/5HWgL.png" alt="inbound security groups"></p>
  
  <p><strong>Outbound security group</strong></p>
  
  <p><img src="https://i.stack.imgur.com/deO4r.png" alt="outbound security groups"></p>
  
  <p><img src="https://i.stack.imgur.com/6IcGF.png" alt="mysql insert query"></p>