Tom Crimmins wrote:
> 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.
>
I definitely don't.. I even went through all the variables using 'show
variables;' and found nothing in there that could attribute to my
problem. This is becoming really baffling.. I may try a source compile
aside from this and try that to see if there is anything different.
Ian
