Hello.
>MySQL cannot resolve this servers hostname for brief
>periods around the same time every day.
You can disable the hostname cache by starting the server with the
--skip-host-cache option.
But the performance can slow down. You may use nslookup to check the correct
work of the
On Thursday 17 February 2005 12:29 pm, Ian Meyer wrote:
> > You have a server thats on DHCP? Well, your problem is dhcp I am sure..
> > But good luck with that horror flick.
>
> Our servers IPs are static, as is the DNS in /etc/resolv.conf
Then you need to make sure its compiled to the right glib
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 begin with. Our
acces
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 begin with. Our
> access tables are
hursday, 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:
> >
> >
> >>When trying to connect, it fails with the message:
> >
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 not using a host. grant
[EMAIL PROTEC
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.
Example:
cre
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 not using a host. grant
[EMAIL PROTECTED] and thing
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.
> >>
> >
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'@'host' identified by
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'@'host' identified by 'xxx
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 command.
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 com
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' identif
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' identifie
16 matches
Mail list logo