I have a mysql instance (and schema) running on windows that I can access via a connection string based on localhost as the server.
now I want to be able to access this db from another machine on the same subnet.
If possible I would like to use a single user but allow it to access from any machine on the same subnet.
how do I setup security for this? (I already opened the relevant firewall port)
Thanks, Eyal
You can do it like this:
change subnet and IP accordingly
You can also use wildcards, rather than a masks.
See the Account Names and Passwords section of the in the
GRANT
docs.