From: Robert Browne
Date: April 24 1999 12:39am
Subject: Re: Password bug
List-Archive: http://lists.mysql.com/mysql/2311
Message-Id: <19990424103914.B516@me.asn.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Wed, Apr 21, 1999 at 10:12:12PM -0500, Paul DuBois wrote:
> 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.

Set up using mysql_install_db, it works now. Changes i made were
removed space between the comma and password in the password field.
And, hostname=`hostname -f`


> >$ 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.


Did not find this tip in the docs, works fine.

                                          
               />          Take care, Rob  ;-)
  (           //------------------------------------------------------,
 (*)OXOXOXOXO(*>=================---------                             >
  (           \\------------------------------------------------------'
               \>    http://www.alphalink.com.au/~rbrowne/linux.htm