List:General Discussion« Previous MessageNext Message »
From:John Trammell Date:February 17 2005 6:03pm
Subject:RE: MySQL and DNS problem
View as plain text  
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
> 
> 
Thread
MySQL and DNS problemIan Meyer17 Feb
  • Re: MySQL and DNS problemMichael Dykman17 Feb
    • Re: MySQL and DNS problemIan Meyer17 Feb
      • Re: MySQL and DNS problemMichael Dykman17 Feb
        • Re: MySQL and DNS problemIan Meyer17 Feb
  • Re: MySQL and DNS problemJeff Smelser17 Feb
    • Re: MySQL and DNS problemIan Meyer17 Feb
      • Re: MySQL and DNS problemJeff Smelser17 Feb
        • Re: MySQL and DNS problemIan Meyer17 Feb
          • Re: MySQL and DNS problemJeff Smelser17 Feb
RE: MySQL and DNS problemTom Crimmins17 Feb
  • Re: MySQL and DNS problemIan Meyer17 Feb
RE: MySQL and DNS problemTom Crimmins17 Feb
  • Re: MySQL and DNS problemIan Meyer17 Feb
RE: MySQL and DNS problemJohn Trammell17 Feb
  • Re: MySQL and DNS problemIan Meyer17 Feb