Can t connect to MySQL server error 111

Question

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    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      Connect from another machine it also error 111    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    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   Help please  Thank

User · Answer

111 means connection refused  which in turn means that your mysqld only listens to the localhost interface   To alter it you may want to look at the bind-address value in the mysqld section of your my cnf file

User · Answer

If all the previous answers didn t give any solution  you should check your user privileges   If you could login as root to mysql then you should add this   CREATE USER  root   192 168 1 100  IDENTIFIED BY         GRANT ALL PRIVILEGES ON       TO   root   192 168 1 100  IDENTIFIED BY        WITH GRANT OPTION MAX QUERIES PER HOUR 0 MAX CONNECTIONS PER HOUR 0 MAX UPDATES PER HOUR 0 MAX USER CONNECTIONS 0     Then try to connect again using mysql -ubeer -pbeer -h192 168 1 100  It should work

User · Answer

It probably means that your MySQL server is only listening the localhost interface   If you have lines like this    bind-address   127 0 0 1   In your my cnf configuration file  you should comment them  add a   at the beginning of the lines   and restart MySQL   sudo service mysql restart   Of course  to do this  you must be the administrator of the server

User · Answer

If you re running cPanel WHM  make sure that IP is whitelisted in the firewall  You will als need to add that IP to the remote SQL IP list in the cPanel account you re trying to connect to

[mysql] Can't connect to MySQL server error 111

Examples related to mysql

Examples related to linux

Examples related to mysql-error-2003