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: > [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.
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
