From Gentoo Linux Wiki
- 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
