On Thursday, February 17, 2005 10:26, Ian Meyer wrote:
> Tom Crimmins wrote:
>> On Thursday, February 17, 2005 09:41, Ian Meyer wrote:
>>
>>> Hello everyone,
>>>
>>> We have a few MySQL servers (4.1.8) running on RedHat ES3. We're
>>> having problems when trying to use hostnames in the grant command.
>>>
>>> Example:
>>> create database blah;
>>> grant all on blah.* to 'user'@'host' identified by 'xxxx';
>>> (also have used the FQDN instead of just host)
>>>
>>> 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'
>>>
>>> Our DNS servers have correct forward and reverse entries for all of
>>> our machines. I read the docs about MySQL and DNS, but I still can't
>>> figure this out.
>>
>>
>> I know you said you have correct reverse entries, but just as a test
>> if you run 'host 192.168.2.103' on the mysql host, does it give back
>> the hostname you used in your grant?
>
> This was run on the database server:
> [imeyer@xxxx imeyer]$ host 192.168.2.103
> 103.2.168.192.in-addr.arpa domain name pointer xxxxx.xxxxx.com.
> [imeyer@xxxx imeyer]$ host xxxxx.xxxxx.com
> xxxxx.xxxxx.com has address 192.168.2.103
>
> The error message MySQL shows the IP address.
You don't happen to have skip-name-resolve in your my.cnf do you? I'm sure
you probably already checked that. I think the grant will create a
warning anyway if you try to give a hostname with this option enabled.
--
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
