List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 22 1999 3:12am
Subject:Re: Password bug
View as plain text  
At 9:01 PM -0500 4/21/1999, Robert Browne wrote:
>To the mysql mailing list
>
>VERSION="3.21.33b"
>From debian package= mysql-server_3.21.33b-2.deb
>COMPILATION_COMMENT="Source distribution"
>BUGmysql="mysql@stripped"
>
>There is a bug with passwords in this package.
>
>With no root password in mysql user file, connection to mysql is fine.
>
>
>With root password in the mysql user file:
>
># mysql -p[.......] mysql
># mysql -p[.......] test
>
>Access to user denied root@localhost (using password yes)

Perhaps you didn't specify the correct password.  You don't say
how you set up the password initially, but if you inserted it into
the user table without using PASSWORD(), access will be denied.

>$ mysql -u root mysql
># mysql mysql
># mysql test
>
>Access to user denied root@localhost (using password no)
>Note: there is no prompt for a password

That's because you didn't ask for a prompt.  Specify -p
or --password on the command line with no password immediately
following it, and mysql will prompt you for one.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Password bugRobert Browne22 Apr
  • Re: Password bugDarrell Shifflett22 Apr
Re: Password bugPaul DuBois22 Apr
  • Re: Password bugRobert Browne24 Apr