John Trammell wrote:
> You can specify a wildcard in the host IP, eg.
>
> grant select on mydb.* to 'someuser'@'192.168.2.%' ...
>
> which you can use to get around your DHCP issue until host lookups are
> fixed.
Host lookups aren't broken using the `host` command.. only when MySQL
goes to look them up, which is the problem.
>
>
>>-----Original Message-----
>>From: Ian Meyer [mailto:imeyer@stripped]
>>Sent: Thursday, February 17, 2005 11:46 AM
>>To: mysql@stripped
>>Subject: Re: MySQL and DNS problem
>>
>>Jeff Smelser wrote:
>>
>>>On Thursday 17 February 2005 09:41 am, Ian Meyer wrote:
>>>
>>>
>>>
>>>>When trying to connect, it fails with the message:
>>>>'MySQL Error Number 1045
>>>>Access denied for user 'user'@'192.168.2.103' (using password: YES'
>>>
>>>
>>>The 192.168.2.103 is your tip that its not using a host. grant
>>>user@stripped and things will work.
>>>
>>>Then you can solve why its not resolving.
>>>
>>>Jeff
>>
>>I wish we could do that, however, it's not an option as we
>>use DHCP.. so
>>the IP's change, yet the hostname does not. Besides, that's
>>just a cheap
>>way to avoid fixing the problem when it should work to begin
>>with. Our
>>access tables are ridiculously messy as you can guess.
>>
>>Ian
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>>http://lists.mysql.com/mysql?unsub=1
>>
>>
