List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:October 20 2005 3:47am
Subject:RE: database won't load after machine reboot
View as plain text  
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!

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
database won't load after machine rebootLuke Vanderfluit20 Oct
  • Re: database won't load after machine rebootLuke Vanderfluit20 Oct
    • Re: database won't load after machine rebootTim Wood20 Oct
RE: database won't load after machine rebootSST - Adelaide)20 Oct
  • Re: database won't load after machine rebootLuke Vanderfluit20 Oct
RE: database won't load after machine rebootSST - Adelaide)20 Oct
  • Re: database won't load after machine rebootLuke Vanderfluit20 Oct
RE: database won't load after machine rebootSST - Adelaide)20 Oct
  • Re: database won't load after machine rebootLuke Vanderfluit20 Oct
    • Re: database won't load after machine rebootScott Haneda20 Oct
    • Re: database won't load after machine rebootGleb Paharenko21 Oct
RE: database won't load after machine rebootSST - Adelaide)20 Oct
  • Re: database won't load after machine rebootLuke Vanderfluit20 Oct