Hello,
>Did you enter an password or did you just type an empty line.
Yes, I type in a password when attempting to login.
>If you entered a password, then the bug may be in your systems
>'getpass()' command.
I'm not sure what problem there might be with the getpass() command.
But, when it calls getpass() it returns a string containing the password I
entered.
| localhost | hodel | 378b243e220ca493 | Y
foo: {121} % ./mysql -u hodel -p
Enter password:
pass = test
Access denied for user: 'hodel@localhost' (Using password: NO)
What does the "Using password: NO" mean? Shouldn't that be YES, even
if the passwor is incorrect?
Thanks,
Ray Hodel
----- Original Message -----
From: Michael Widenius <monty@stripped>
To: Ray Hodel <hodel@stripped>
Cc: <mysql@stripped>
Sent: Sunday, August 29, 1999 2:21 PM
Subject: Using Passwords on BSDI 4.01 with MySQL 3.22.25
>>>>>> "Ray" == Ray Hodel <hodel@stripped> writes:
>
>Ray> Is there an issue with MySQL 3.22.25 on BSDI 4.01 when using
Passwords.
>mysql> select host, user, password from user;
>Ray> +----------------+----------+------------------+
>Ray> | host | user | password |
>Ray> +----------------+----------+------------------+
>Ray> | localhost | root | |
>Ray> | foo.com | root | |
>Ray> | localhost | someuser | 7f9331456a61df60 |
>Ray> | foo.com | someuser | 7f9331456a61df60 |
>Ray> +----------------+----------+------------------+
>Ray> 3 rows in set (0.00 sec)
>
>Ray> When I attempt to connect to the database it gives an "Access denied"
>Ray> message.
>
>Ray> foo: {12} % mysql -h foo.com -u someuser -p
>Ray> Enter password:
>Ray> ERROR 1045: Access denied for user: someuser@stripped' (Using password:
NO)
>
>Ray> I've noticed that on a Linux system running the same version of MySQL,
using
>Ray> the
>Ray> same persmissions, I can login. Plus, when I typed in an incorrect
password
>Ray> it would
>Ray> display "(Using password: YES)".
>
>Did you enter an password or did you just type an empty line.
>
>If you entered a password, then the bug may be in your systems
>'getpass()' command.
>
>Easy fix:
>
>remove 'HAVE_GETPASS' from config.h and recompile
>
>Regards,
>Monty
