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 <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (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" <[EMAIL PROTECTED]> 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: '[EMAIL PROTECTED]' (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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]
_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de medio millón de canciones. http://music.msn.es/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
