title: Host is not allowed to connect to this MySQL server for client-server application
body: <p>I just exported my tables from one web host to another (AWS).
  Thinking everything would go smoothly (yeah right), well, everything that can go wrong has gone wrong.</p>
  
  <p>I get this error when trying to query my database (which I didn't get before):</p>
  
  <p><code>SQLSTATE[HY000] [1130] Host '&lt;my ip address&gt;' is not allowed to connect to this MySQL server</code></p>
  
  <p>This is the same error from this post:</p>
  
  <p><a href="https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server">Host &#39;xxx.xx.xxx.xxx&#39; is not allowed to connect to this MySQL server</a></p>
  
  <p>The solution in that post seems to revolve around having an administrative user.    I am developing a chat application so every user needs to access the server (so I'm sure it's a bad idea to give them all administrative privileges).
  The answer by Pascal in that link says, <code>If you are using mysql for a client/server application, prefer a subnet address.</code> but I honestly don't understand what he means by that.  And because of the amount of solutions, I'm not exactly sure which one I should follow based on my case.</p>
  
  <p>How do I resolve this?</p>