title: Connecting to MySQL from Workbench
body: <p>MySQL remote access</p>
  
  <p>I have a mysql database, running on Ubuntu Server 12.04 that I need to access remotely. For some reason this is become much more of a chore than I think it should be.</p>
  
  <p>I have been through countless threads trying to resolve this issue with no luck what so ever. I do not have another linux box to test my connection. I am only using the MySQL Workbench from a Window 7 machine.</p>
  
  <p>Here is what I have done so far:</p>
  
  <ul>
  <li>set the iptables to accept</li>
  <li>set the my.cnf to have the bind address of the server</li>
  <li>created a user for both localhost and %</li>
  <li>grant all to those users</li>
  <li><p>restarted mysql</p></li>
  <li><p>verified the user has all priv</p></li>
  <li>verified mysql is listening on 3306</li>
  </ul>
  
  <p>give the correct setting to Workbench and I get 
  "Your connection attempt failed for user 'USER' from your host to server at x.x.x.x:3306:
   Can't connect to MySQL server on 'x.x.x.x' (10061)"</p>
  
  <p>EDIT: I did notice that it show 'localhost and NOT the ipaddress when I run this cmd, but i'm not sure how to change that, or if it is even the issue. Thoughts?</p>
  
  <p><code># lsof -i -P | grep :3306</code></p>
  
  <p><code>mysqld   5775    mysql   10u  IPv4 154265      0t0  TCP localhost:3306 (LISTEN)</code></p>