Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
SQL goes to look them up, which is the problem. -Original Message- From: Ian Meyer [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:46 AM To: mysql@lists.mysql.com Subject: Re: MySQL and DNS problem Jeff Smelser wrote: On Thursday 17 February 2005 09:41 am, Ian Meyer wrote: W

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
Jeff Smelser wrote: On Thursday 17 February 2005 11:46 am, Ian Meyer wrote: I wish we could do that, however, it's not an option as we use DHCP.. so the IP's change, yet the hostname does not. Besides, that's just a cheap way to avoid fixing the problem when it should work to

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
Jeff Smelser wrote: On Thursday 17 February 2005 09:41 am, Ian Meyer wrote: 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' The 192.168.2.103 is your tip that its n

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
Michael Dykman wrote: On Thu, 2005-02-17 at 12:21, Ian Meyer wrote: Michael Dykman wrote: 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. Ex

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
Michael Dykman wrote: 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'@&#

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
Tom Crimmins wrote: 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 co

Re: MySQL and DNS problem

2005-02-17 Thread Ian Meyer
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 'u

MySQL and DNS problem

2005-02-17 Thread Ian Meyer
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 ''; (also have used the FQDN instead of just host) When trying