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:[EMAIL PROTECTED] > Sent: Thursday, February 17, 2005 11:46 AM > To: mysql@lists.mysql.com > 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 > > [EMAIL PROTECTED] 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
