title: Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
body: <p>This should be dead simple, but I <em>cannot</em> get it to work for the life of me.<br />
  I'm just trying to connect remotely to my MySQL server.</p>
  <ul>
  <li><p>Connecting as:</p>
  <pre class="lang-bash prettyprint-override"><code>mysql -u root -h localhost -p  
  </code></pre>
  </li>
  <li><p>works fine, but trying:</p>
  <pre class="lang-bash prettyprint-override"><code>mysql -u root -h 'any ip address here' -p
  </code></pre>
  </li>
  <li><p>fails with the error:</p>
  <blockquote>
  <p>ERROR 1130 (00000): Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server</p>
  </blockquote>
  </li>
  </ul>
  <p>In the <code>mysql.user</code> table, there is exactly the same entry for user 'root' with host 'localhost' as another with host '%'.</p>
  <p>I'm at my wits' end and have no idea how to proceed.
  Any ideas are welcome.</p>