Manually reset WordPress admin password using MySQL phpMyAdmin

mysql logoTo reset WordPress admin password from MySQL database, follow the simple steps

1) Login to cPanel and open the database used by WordPress in phpMyAdmin.
2) Click on MySQL icon at the top of the navigation bar.
3) In the query field, execute the following query

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password_here' ) WHERE `wp_users`.`user_login` = "admin_username";

"new_password_here" - replace this with the new password you wish to use.
"admin_username" - replace this with the username the password should be updated for.

4) Click on Go button to run the query.
5) Try logging in the WordPress admin area now.

This can also be done from shell and using MySQL database.

If any feedback, queries are always welcome!

Share on Facebook0
Share on Google+3Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn0Share on Tumblr0Digg thisPin on Pinterest0Share on Reddit0Email this to someonePrint this page

About Abhijit Sandhan

Abhijit Sandhan
Loves Linux, Blogging, Traveling, Hiking and sharing knowledge!

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA