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(servernameortetc,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?
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(servernameortetc,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?