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:lvanderf@stripped]
>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
