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:
[EMAIL PROTECTED] imeyer]$ host 192.168.2.103
103.2.168.192.in-addr.arpa domain name pointer xxxxx.xxxxx.com.
[EMAIL PROTECTED] imeyer]$ host xxxxx.xxxxx.com
xxxxx.xxxxx.com has address 192.168.2.103
The error message MySQL shows the IP address.
Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]