MySQL Forums
Forum List  »  Security

Re: How to restore the root account?
Posted by: Sebastien Caisse
Date: January 04, 2006 09:11AM

Might want to change the init file to create the root account instead:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION

For more info on creating users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

[I never tried this and cannot test it at the moment]

Options: ReplyQuote


Subject
Views
Written By
Posted
22470
February 01, 2005 10:28AM
13867
February 01, 2005 11:51AM
9102
February 02, 2005 03:34AM
13841
December 25, 2005 11:32AM
Re: How to restore the root account?
29021
January 04, 2006 09:11AM


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.