Search:  
Gentoo Wiki

HOWTO_Password_reset_procedure

This page is a candidate for deletion 
Reason given: Article is incomplete, unformatted and covered better by the MySQL manual.
If you disagree with its deletion, please explain why on its discussion page.
If you intend to fix it, please remove this notice, but do not remove this notice from articles that you have created yourself.
Make sure no other pages link here and check the page's history before deleting.
Reset my root password Version 4.xx, 5.xx


1.Login as root

2.Restart the mysql server (/etc/init.d/mysql restart) with the skip-grant-tables option (edit my.cnf and add: skip-grant-tables)

3.Connect to the mysql server by using:
Code:

myserver # mysql -u root mysql

then to reset the password: 
Code:

myserver # mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
myserver # mysql> FLUSH PRIVILEGES;

Peter Koegel  Dec 08,2006 
Retrieved from "http://www.gentoo-wiki.info/HOWTO_Password_reset_procedure"

Last modified: Tue, 04 Sep 2007 10:52:00 +0000 Hits: 5,170