RE: [cobalt-developers] MySQL

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

> 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)


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