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]