RE: RE: [cobalt-developers] MySQL

[travis@xxxxxxxxxxxxxxxx]

Did you forget your password?

Travis

---- Original Message ----
From: Kevin M Carolan <kevinc@xxxxxxxxxxxxxxxx>
Sent: 2001-12-03 05:19:32.0
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-developers] MySQL


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)


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

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers