[TriLUG] mysql root pw with non-interactive lamp server install?

[Tom Barron]

Hmm, I wonder if I'm running into a new release thing with ubuntu
karmic.  If I do 'mysql -u root -p' and then respond with a simple
<CR>, a ''<CR>, or ' '<CR>  I still get the error described below.

Or is there some better way to enter a blank password?

I have by the way tried the same variants on the command line
immediately after the '-p' and in the '--password=<pw>' form of argv.

- Tom

On Tue, 2009-11-03 at 10:57 -0500, Lee Fickenscher wrote:
> I believe in this case the root password is blank.
> 
> On Mon, Nov 2, 2009 at 9:01 PM, Tom Barron <tpb at dyncloud.net> wrote:
> 
> > I hit a snag at (1) since there already appears to be a mysql root
> > password set and I don't know what it is.  'mysql -u root' fails with
> >
> > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> > password: NO)
> >
> > And 'mysql -u root -p' fails because I don't know the password that
> > was set.
> >
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG FAQ  : http://www.trilug.org/wiki/Frequently_Asked_Questions
-- 
  Tom Barron
  tbarron at dyncloud.net
  +1 919-619-7572