>>>>> "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
