MySQL Forums

Guys,
I know you can create a wildcard "grant" for local subnet IP's by '192.168.%.%' or all IP's by '%', but this syntax is NOT working when the local subnet resolves as the individual machine name that's trying to connect.
Example: hostname='myPCname' so mysql sees the connection coming from:
username@myPCname instead of username@192.168.1.6
even though they are one and the same address on the subnet

How do you create a wildcard grant that works for all the unique developer machine names that need to connect when they are on a local windows network and the IP is not used???

This is frustrating---all advice appreciated!!
Thanks
Dewey