Check out the Documentation, this is covered in chapter 6. The MySQL access privilege system.
The user jdoe can have localhost access, or anyhost access by placing % as the host name. You can also grant jdoe access from any host on your subnet.
Ian wrote:
I am trying to connect to a mysql on one IP address from another remote IP.
i.e. the script is running on a webserver with IP address 10.1.1.2 and is trying to connect to a mysql server on IP address 10.1.1.1
When I try to connect using mysql_connect(servername:portetc,UID,PWD) a get an error saying that the IP is not aloud to connect to that particualr database.
I assume there is something in the config of mysql that allows me to grant access rights to other ips than the local host.
What I wanna know is how do I do it?
