MySQL Forums
Forum List  »  Perl

Retriving Root Account and PW
Posted by: Thomas Wise
Date: June 11, 2009 12:55AM

Hello to all,

I have lost my root account and looked up on internet a possible solution, which was :
1) Shut down mysql (locally)

2) executed :
UPDATE mysql.user SET Password=PASSWORD("some_new_password") WHERE User="root";

3) re-started mysql

4)easyPHP : when to admin

5) type in : user : root, password : some_new_password

still can not connect as root!

Is there another way about restoring the root account ?

Thanks to anyone that can help me

PS : phpMyAdmin
Version du client MySQL: 5.0.22

Options: ReplyQuote

Written By
Retriving Root Account and PW
June 11, 2009 12:55AM

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.