Quote:
Originally Posted by .=QUACK=.Major.pain
Not exactly what I was asking.
If a game server is on a rented server, and a website is also on the same rented server, but with different ip's, does remote sql permissions still have to be set up?
If they by share the same ip, I guess it wouldn't be required.
|
AFAIK, MySQL users are identified by an IP-filter - All of them. Each user has it's own IP-filter. This means that anything that connects to MySQL database TCP/IP port, require that the login username/password and the IP-filter matches the user, even if connected locally.
"Remote permissions" from outside the MySQL hosted IP require a
hole in the firewall (MySQL TCP/IP listener port) and a DB user with proper IP-filter to match the remote connection IP. "Remote permissions" locally usually do not require a firewall
hole, but will still require a DB user with proper IP-filter.
__________________