RE: Problem connecting

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:[email protected]] 
Enviado el: Miércoles, 17 de Mayo de 2006 05:00 p.m.
Para: [email protected]; [email protected]
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: [email protected] [mailto:[email protected]] 
Enviado el: Miércoles, 17 de Mayo de 2006 04:49 p.m.
Para: [email protected]
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...
> 
> [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: [email protected] [mailto:[email protected]] 
> 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

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/[email protected]




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/[email protected]




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]