MySQL Forums
Forum List  »  Newbie

Accidentally deleted root account - backup available, how to restore?
Posted by: Sander Overvliet
Date: March 27, 2006 08:10AM


I've made a major booboo just about an hour ago; I managed to blindly delete the root account from the mysql user list through Webmin while on a cleanup spree. As you might be able to tell i'm completely stuck, no permissions to do anything, and I would really like to get access back.
I have, by stroke of luck, a backup of all databases I made some time ago.. the problem is, without permissions, how do I get it back in there?

Is there any way to do this without completely removing MySQL from my machine and reinstalling it?

Server details:
Mandriva Linux 10.2, MySQL 4.1.11, Apache 2, PHP4, etc.

I've got a backup of the 'mysql' database that I believe holds the usernames/passwords? If I can just restore that i'd be grateful.

Thank you for your time

Edited 1 time(s). Last edit at 03/27/2006 08:11AM by Sander Overvliet.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.