From: Héctor S. Mendoza O.
Date: May 18 2006 2:28pm
Subject: RE: Problem connecting
List-Archive: http://lists.mysql.com/perl/3848
Message-Id: <00c701c67a87$59791940$1501010a@intranet.acorporativa.com.mx>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=E9ctor S. Mendoza Ortiz

-----Mensaje original-----
De: H=E9ctor S. Mendoza O. [mailto:hector@stripped]=20
Enviado el: Mi=E9rcoles, 17 de Mayo de 2006 05:00 p.m.
Para: w@stripped; perl@stripped
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=3D'localhost',user=3D'',passwd=3D'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=E9ctor S. Mendoza Ortiz

-----Mensaje original-----
De: w@stripped [mailto:w@stripped]=20
Enviado el: Mi=E9rcoles, 17 de Mayo de 2006 04:49 p.m.
Para: perl@stripped
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

  +---------------+---------+------------------+
  | host          | user    | password         |
  +---------------+---------+------------------+
  | localhost     | root    | 6ab112233de44558 |

New passwords are longer:

  +-----------+---------+-------------------------------------------+
  | host      | user    | password                                  |
  +-----------+---------+-------------------------------------------+
  | localhost | root    | *17A3A389744F3F39AC4CE4CCFCAD6960D8EA03C9 |

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...
>=20
> [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
>=20
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>=20
> mysql> quit
> Bye
> [root@chihuahua root]#
>=20
> TIA
>=20
> H?ctor S. Mendoza Ortiz
>=20
> -----Mensaje original-----
> De: w@stripped [mailto:w@stripped]=20
> Enviado el: Mi?rcoles, 17 de Mayo de 2006 03:34 p.m.
> Para: H?ctor S. Mendoza O.
> Asunto: Re: Problem connecting
>=20
> 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.
>=20
> 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
>=20
> It sounds you have empty password set for user web@localhost.
> Try
>     SELECT host,user,password FROM user
> to see what is actually set.
>=20
> --w

--=20
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=3Dhector@stripped




--=20
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=3Dhector@stripped