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
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
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
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
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'@
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
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
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