[How To] Reset WordPress admin password using MySQL / phpMyAdmin

mysql logo

To 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 Facebook0Share on Google+0Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn0Share on Tumblr0Pin on Pinterest0Email 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 *