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:hector@stripped]
Enviado el: Miércoles, 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='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@stripped [mailto:w@stripped]
Enviado el: Miércoles, 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...
>
> [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@stripped [mailto:w@stripped]
> 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/perl?unsub=1
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=1
