Re: [cobalt-users] mySQL nightmare

[Ted Behling <TBehling@xxxxxxxxxxxxx>]

Oh, fun!  Shut down your MySQL daemon and start it up with the
--skip-grant-tables parameter.  That'll give everyone full access to
everything, so you should log in with no problem.  Reset your root password
with:

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Then restart your daemon as usual.

At 01:51 PM 8/7/01 +0100, Paul Brown wrote:
>Since my co-locator installed mySQL I have had nightmares with it. Now in
the end I either have the wrong root password or I cannot
>connect from any host. Either way Im screwed.
>
>I have been on mySQL message boards, but don't seen to get the quality of
answers there as I do here.
>
>Would someone be kind enough to inform me as to how to reset the root
password (what actually to type in and not a description of
>what to do) or advise me on how to uninstall mySQL without the mySQL
password.


--------------------------------------------------------------------------
Ted Behling, Web Application Developer - Monarch Information Systems, Inc.

43 Folly Field Road, Unit 4, Hilton Head Island, SC 29928-5434
E-mail: mailto:TBehling@xxxxxxxxxxxxx
Phone/Fax: 1-800-842-7894    Local or Outside the USA: 1-843-842-7894
Cell Phone (urgent issues): 843-816-7895
Cell Phone E-mail: mailto:TedPhone@xxxxxxxxxxxxx (116 letter limit)
Web site: http://www.MonarchIS.net
--------------------------------------------------------------------------