title: Can't connect to MySQL server error 111
body: <p>I installed mysql server on linux box IP = 192.168.1.100 but when i try to connect to this IP it alway error(111). but use localhost and 127.0.0.1 is OK.</p>
  
  <pre>
  beer@beer-laptop# ifconfig | grep "inet addr"
            inet addr:127.0.0.1  Mask:255.0.0.0
            inet addr:192.168.1.100  Bcast:192.168.1.255  Mask:255.255.255.0
  
  beer@beer-laptop# mysql -ubeer -pbeer -h192.168.1.100
  ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
  
  beer@beer-laptop# mysql -ubeer -pbeer -hlocalhost
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 160
  Server version: 5.1.31-1ubuntu2 (Ubuntu)
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
  mysql> 
  
  beer@beer-laptop# mysql -ubeer -pbeer -h127.0.0.1
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 161
  Server version: 5.1.31-1ubuntu2 (Ubuntu)
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
  mysql> 
  
  </pre>
  
  <p>Connect from another machine it also error 111.</p>
  
  <pre>
  another@another-laptop# mysql -ubeer -pbeer -h192.168.1.100
  ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
  </pre>
  
  <p>How difference between use localhost/127.0.0.1 and 192.168.1.100 in this case. 
  I don't know how to connect to this database from another machine.</p>
  
  <p>Help please.
  Thank.</p>