On Thu, 2005-02-17 at 10: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.
>
> Thanks,
> Ian
Instead, try determining what the ips the host names resolve to (not the
other way around) If you are GRANTing to [EMAIL PROTECTED] , you want to make
sure that when the machine 'foo' connects, it is connecting as the same
ip address the 'foo' resolves to when the server looks it up
for example,
$ host foo
might translate to foo.domain.com -> 20.20.20.21 [external ip]
but foo is connecting as 192.168.1.21 [internal ip]
and Mysql will reject the connection.
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
