mysql_connect - using IP address as host name?

[KendersPlace]

I just noticed something interesting.... usually when using mysql_connect() from php, I've specified the host name as "localhost" which has worked fine.

If I use the IP address "127.0.0.1", it still works fine, but if I specify the actual IP address bound to the NIC card in that box, (ex: 192.168.1.100), it fails to open the DB connection. There is no firewall running on this test box, so the firewall is not blocking it. How do I configure mysql to accpet connections to its own IP?

The point of this is to use mysql_connect() to connect to a remote mysql server using that server's IP address, and from my test above, it seems this is not possible unless I modify the mysql configuration, but not sure what to modify.

[superwormy]

http://www.mysql.com/doc/en/Privilege_system.html

http://www.mysql.com/doc/en/Connection_access.html

If you get phpMyAdmin it's very easy to edit the privilidges of users in the 'users' table, or through phpMyAdmin's builtin user stuff.

[KendersPlace]

Outstanding. Thanks. I'd looked over the mysql docs but apparently missed this section.

I am using phpmyadmin - great GUI program. It sure makes table creation and maintenance quick and simple.