title: mysql: connection refused when trying to connect to localhost using remote IP
body: <p>When I try to connect to a local mysql database using it's remote ip-address I get a access denied. When I try to connect to that same database from an external machine, it works without any problems. When I connect to the local database using localhost, it works perfectly as well. E.g., if the database server has the ip 1.2.3.4 then I get the following results:</p>
  
  <pre><code># From the db server
  mysql -u username -h localhost -p #works perfectly
  mysql -u username -h 127.0.0.1 -p #works perfectly
  mysql -u username -h 1.2.3.4 -p #Access denied
  
  # From any other machine
  mysql -u username -h 1.2.3.4 -p #works perfectly
  </code></pre>
  
  <p>What can I do to allow local access to my database using its remote ip-address? The OS of the database server is Fedora 15 and the MySQL version is 5.5.23.</p>