RE: Problem connecting - Héctor S. Mendoza O. - com.mysql.lists.perl

17 messages in com.mysql.lists.perlRE: Problem connecting

From	Sent On	Attachments
Héctor S. Mendoza O.	16 May 2006 19:18
Hung Tran	17 May 2006 06:22
Héctor S. Mendoza O.	17 May 2006 07:01
Patrick Galbraith	17 May 2006 10:15
Héctor S. Mendoza O.	17 May 2006 10:31
Patrick Galbraith	17 May 2006 10:35
Héctor S. Mendoza O.	17 May 2006 10:42
Héctor S. Mendoza O.	17 May 2006 11:00
Patrick Galbraith	17 May 2006 11:04
Patrick Galbraith	17 May 2006 11:07
Héctor S. Mendoza O.	17 May 2006 11:23
Patrick Galbraith	17 May 2006 11:31
Héctor S. Mendoza O.	17 May 2006 11:44
Héctor S. Mendoza O.	17 May 2006 14:22
Vladimir V. Kolpakov	17 May 2006 14:48
Héctor S. Mendoza O.	17 May 2006 14:59
Héctor S. Mendoza O.	18 May 2006 07:28

Subject:	RE: Problem connecting
From:	Héctor S. Mendoza O. (hec...@acorporativa.com.mx)
Date:	05/18/2006 07:28:13 AM
List:	com.mysql.lists.perl

Hello all...

First of all, thanks a lot to everybody that tried to help out in the problem I had.... in the end what I ended up doing is I pulled out a backup of all the databases one day before the breakdown, uninstalled mysql, reinstalled (in the process upgraded and added some patches) and now my app is working again.

Like I said thanks again to everybody that helped out!

Héctor S. Mendoza Ortiz

-----Mensaje original----- De: Héctor S. Mendoza O. [mailto:hec...@acorporativa.com.mx] Enviado el: Miércoles, 17 de Mayo de 2006 05:00 p.m. Para: w...@sfgate.com; pe...@lists.mysql.com Asunto: RE: Problem connecting

I have only one entry for the 'web' user

+------+------+-------------------------------------------+ | host | user | password | +------+------+-------------------------------------------+ | % | web | *AA5DDEDA13B2251610E9F1ED81642FB705BABDE4 | +------+------+-------------------------------------------+

I've tried again changing this to old password style, but still nothing.

There are no anonymous users (ie. Host='localhost',user='',passwd='x'), I already checked that for precedence on search for password on users

I already tried adding a host for localhost, for the IP address, for the hostname of the server and I have the same result.

Thanks again for all the help received!

Héctor S. Mendoza Ortiz

-----Mensaje original----- De: w...@sfgate.com [mailto:w...@sfgate.com] Enviado el: Miércoles, 17 de Mayo de 2006 04:49 p.m. Para: pe...@lists.mysql.com Asunto: Re: Problem connecting

Now, what

SELECT host,user,password FROM user

shows? (not needed to show output in email)

Where you have old passwords, they will be short, such as

New passwords are longer:

If your web server is not localhost, mix of web's old and new passwords may cause connection failure.

--w

On Wed, May 17, 2006 at 04:23:18PM -0500, H?ctor S. Mendoza O. wrote:

Here it is...

[root@chihuahua root]# mysql -uweb -hlocalhost -psecret planos Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 to server version: 4.1.10a-Max-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit Bye [root@chihuahua root]#

TIA

H?ctor S. Mendoza Ortiz

-----Mensaje original----- De: w...@sfgate.com [mailto:w...@sfgate.com] Enviado el: Mi?rcoles, 17 de Mayo de 2006 03:34 p.m. Para: H?ctor S. Mendoza O. Asunto: Re: Problem connecting

On Wed, May 17, 2006 at 01:01:18PM -0500, H?ctor S. Mendoza O. wrote:

[root@chihuahua cgi-bin]# mysql -u web -h localhost -p planos Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.

Last argument in command line is the database name, thus password is invisible here and confusing. Use no spaces after option key to be certain: mysql -uweb -hlocalhost -psecret planos

It sounds you have empty password set for user web@localhost. Try SELECT host,user,password FROM user to see what is actually set.

--w