I haven't tried it yet, but I'll try it next time it happens, to see if
the problema disappears.
We actually have some connection problems that can be relevant to my
problem:
Warning: Lost connection to MySQL server during query in
/home/httpd/...some.php on line 9
We solved them by the PHP code: Now we reconnecto to mysql if the
mysql_connect() command fails. If the connect command fails, then we try 10
more times.
Could be that the connect command fails, then I start trying and trying,
and then the server blocks because it receives too many connections? Then
the error message would be the one that I'm getting?
Thanx in advance,
Jorge
>From: Gleb Paharenko <gleb.paharenko@stripped>
>To: mysql@stripped
>Subject: Re: Access denied for user: 'apache@localhost' (Using password:
>NO)
>Date: Mon, 18 Apr 2005 18:38:54 +0300
>
>Hello.
>
>It is strange that refusing message says you're not using passwords.
>Does the problem disappear after the "FLUSH HOSTS" statement, instead of
>restarting MySQL server?
>
>
>
>
>"Jorge Cambra Aused" <jorge_cambra_aused@stripped> wrote:
> >
> > I have a web application running with Apache with PHP 4.1.2 (revision
> > 7.2.6) and MySQL 3.23.58.
> >
> > The access from the PHP code to the MySQL server using the IP of the
> > machine with MySQL, an username and a password, and it works fine.
> >
> > But sometimes we get the MySQL error:
> >
> > Access denied for user: 'apache@localhost' (Using password: NO)
> >
> > All the connections to the database fails for this reason, and we are
>sure
> > that we are passing correctly the username, password and IP address. If
>we
> > restart MySQL, then the problems disappears, and it works fine, but we
>don't
> > know why it happens.
> >
> > The username that we are using to access MySQL is not 'apache', apache,
>as
> > you can guess, is the name of the user that is running Apache.
> >
> > Thanx in advance,
> > Jorge Cambra
> >
> > _________________________________________________________________
> > Descarga gratis la Barra de Herramientas de MSN
> >
>http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH
> >
> >
>
>
>--
>For technical support contracts, goto https://order.mysql.com/?ref=ensita
>This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>
_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de medio millón de
canciones. http://music.msn.es/
