Uncategorized

[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";

Where
"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!

Abhijit Sandhan

Love to Automate, Blog, Travel, Hike & spread Knowledge!

Related Articles

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top button