I am trying to setup a mysql server on my machine. I would like to limit the domains that it listens for connections to. My understanding is that you can either have it listen to 1 ip or all ip's. Therefore, if i want to connect remotely I have to say all ips. Then I would like to block all domains but the ones I know should actually be connecting.. I believe this is done through windows firewall. However, how do i do this by domain instead of IP?
In mysql users are stored in the form
You can define users in such forms as:
Bear in mind that if you use the same username for two different networks, ie:
their passwords are managed completely separately.
If you require more granular control than this then you will want to use a firewall.
You can view existing users by running: