Use IP address to connect MySQL database in PHP

We usually use mysql_connect ("localhost", "usrname", "password") to connect to the MySQL database in the way we test them.

If we want to use the IP address of other host to connect the MySQL database, we need to modify the MySQL profile/etc/mysql/my.cnf, otherwise this error will appear:

Can t connect to MySQL server on 111

Skip-external-locking

#

# Instead of skip-networking The default is now to listen only

# localhost which are more compatible and are not less secure.

#bind-address = 127.0.0.1//This line is to be commented out

Once you have commented out this line of bind-address and then restart MySQL, you can use the IP address to connect to MySQL via other machines.

See more highlights of this column: http://www.bianceng.cn/webkf/PHP/