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? > > Thanks, > Ian -- 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]
