MySQL Forums
Forum List  »  Security

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

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@
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!!

Options: ReplyQuote

Written By
host wildcard % not working for machine names, only IPs
June 21, 2007 02:19PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.