Hi David.
Logan, David (SST - Adelaide) wrote:
Hi Luke,
Yep, there is a procedure in the manual
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here.
This has all the steps you will need to get root back.
Hope it all ends up ok!
That went well (resetting the root password).
Then the grant statement did the trick.
Thanks.
Kind regards.
Luke.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Luke Vanderfluit [mailto:[EMAIL PROTECTED]
Sent: Thursday, 20 October 2005 12:17 PM
To: mysql
Subject: Re: database won't load after machine reboot
Hi David.
Thanks for your help.
Logan, David (SST - Adelaide) wrote:
Hi Luke,
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).
Kr.
Luke.
--
Luke
