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:[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]
