error with mysql when doing mysql -u root

[Shawn Guillemette]

like this ?

# mysql -u root -p password
Enter password:
ERROR 1045: Access denied for user: 'root at localhost' (Using password: YES)


if so is there a way I can reset the "root"' passwd for mysql?
I have tried mysqladmin -u root passowrd newpassword and get this



Shawn


----- Original Message ----- 
From: "Kevin Kinsey" <kdk at daleco.biz>
To: "Shawn Guillemette" <shawn at guillemette.org>
Cc: <questions at freebsd.org>
Sent: Saturday, September 20, 2003 6:42 AM
Subject: Re: error with mysql when doing mysql -u root


> On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote:
> > After setting the mysql root user passwd I get this when trying to log
in.
> >
> > # mysql -u root
> > ERROR 1045: Access denied for user: 'root at localhost' (Using password:
NO)
> >
> > Just after the install of mysql I had created a database as a test
successfully..
> >
> IIRC, it's: 'mysql -u root -p mypassword'
>
> HTH,
>
> Kevin Kinsey
>