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.
> -----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
>
>
