MySQL can connect with localhost, but cannot use IP connection problem

Ubuntu installed MySQL, through localhost, 127.0.0.1 can be connected, but the use of IP is not connected

Possible causes:

1. View/ETC/MYSQL/MY.CNF

cat/etc/mysql/my.cnf | grep 127

Can see

Bind-address  = 127.0.0.1

MySQL only listens to 127.0.0.1 by default, and it fails with the assigned IP connection.

Comment out the line

# bind-address   = 127.0.0.1

and close MySQL

Service MySQL Stop

Start again

Service MySQL Start

If it is not connected, it may also be a problem with user rights, each user has a login IP

For more details, see http://my.oschina.net/lhplj/blog/273394.

MySQL can connect with localhost, but cannot use IP connection problem