Yep, there is a procedure in the manual
This has all the steps you will need to get root back.
Hope it all ends up ok!
HP Managed Services
148 Frome Street,
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
From: Luke Vanderfluit [mailto:lvanderf@stripped]
Sent: Thursday, 20 October 2005 12:17 PM
Subject: Re: database won't load after machine reboot
Thanks for your help.
Logan, David (SST - Adelaide) wrote:
>Have you tried doing another GRANT statement to ensure the name and
>password are indeed correct? That would be my next step. That way at
>least you are sure that the name/password combination are correct.
I can't access the database as root anymore.
Accessing as other users doesn't allow me to set any GRANT statements.
Is there any way I can reset the root password? (Ouch).
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1