Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Recover a MySQL root password

Simple and smart reset Mysql Root password

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start


This post first appeared on Mysql Tech Tips, please read the originial post: here

Share the post

Recover a MySQL root password

×

Subscribe to Mysql Tech Tips

Get updates delivered right to your inbox!

Thank you for your subscription

×