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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andy Brown Sent: Monday, December 03, 2001 4:36 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://ineedlinux.info/ _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
