Re: MySQL and DNS problem

[Ian Meyer]

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