host wildcard % not working for machine names, only IPs

host wildcard % not working for machine names, only IPs
Posted by: Dewey Gaedcke ()
Date: June 21, 2007 02:19PM


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
=======================
I don't know how MySQL does the reverse IP lookup. But if it uses the hosts file first, you could try to add a line like
192.168.1.6 192.168.1.6
to /etc/hosts so that the name resolves to the similar IP and vice versa.