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/