> 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)
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 [EMAIL PROTECTED] http://ineedlinux.info/ _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
