RE: [cobalt-developers] MySQL

["Andy Brown" <andy.brown@xxxxxxxxxxxxx>]

> Andy,
> 
> That's where I messed up and put a new password in there. How 
> do I get rid of it and run your command.
> 
> I get
> 
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using 
> password: YES)'
> 
> K
> -----Original Message-----
> From: cobalt-developers-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of 
> Andy Brown
> Sent: Monday, December 03, 2001 4:36 AM
> To: cobalt-developers@xxxxxxxxxxxxxxx
> Subject: RE: [cobalt-developers] MySQL
> 
> 
> > shell> mysql -u root -pcobalt-mysql
> > mysql>use mysql;
> > mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE 
> > mysql>user='root';  FLUSH PRIVILEGES;
> >
> > or i believe this will work too:
> > shell> mysqladmin -u root cobalt-mysql new_password
> >
> > -Rob
> 
> 
> Quick correction to the mysqladmin method, it should be 
> mysqladmin -p -u root password new_password
> 
> The word password has to be there to tell mysqladmin what to 
> do, it doesn't mean literally the password! And the -p tells 
> it to prompt you for the current password (which is default 
> set to cobalt-mysql)


Which password did you try entering when it prompted you?? I suspect it
would still be the original 'cobalt-mysql' password
Try that, and also try just pressing enter as it could be a blank
password.

If not then things get a little more tricky!


 Regards,
 Andy
 andy@xxxxxxxxxxxxxxxxxxxxx
 http://ineedlinux.info/