RE: MySQL and DNS problem - Tom Crimmins - com.mysql.lists.mysql

16 messages in com.mysql.lists.mysqlRE: MySQL and DNS problem

From	Sent On	Attachments
Ian Meyer	17 Feb 2005 07:40
Tom Crimmins	17 Feb 2005 08:23
Ian Meyer	17 Feb 2005 08:25
Tom Crimmins	17 Feb 2005 08:47
Ian Meyer	17 Feb 2005 08:49
Michael Dykman	17 Feb 2005 09:17
Ian Meyer	17 Feb 2005 09:21
Michael Dykman	17 Feb 2005 09:38
Jeff Smelser	17 Feb 2005 09:38
Ian Meyer	17 Feb 2005 09:42
Ian Meyer	17 Feb 2005 09:46
John Trammell	17 Feb 2005 10:03
Jeff Smelser	17 Feb 2005 10:08
Ian Meyer	17 Feb 2005 10:28
Ian Meyer	17 Feb 2005 10:32
Jeff Smelser	17 Feb 2005 11:24

Subject:	RE: MySQL and DNS problem
From:	Tom Crimmins (mys...@pottcounty.com)
Date:	02/17/2005 08:23:30 AM
List:	com.mysql.lists.mysql

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