List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 29 1999 6:21pm
Subject:Using Passwords on BSDI 4.01 with MySQL 3.22.25
View as plain text  
>>>>> "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
Thread
Using Passwords on BSDI 4.01 with MySQL 3.22.25Ray Hodel27 Aug
  • Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Vivek Khera27 Aug
  • Using Passwords on BSDI 4.01 with MySQL 3.22.25Michael Widenius29 Aug
Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Ray Hodel27 Aug
Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Ray Hodel30 Aug
  • Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Michael Widenius31 Aug
    • Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Vivek Khera31 Aug
Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Ray Hodel1 Sep
  • Re: Using Passwords on BSDI 4.01 with MySQL 3.22.25Vivek Khera1 Sep