How to Reset wordpress admin password via MySQL query or PhpMyadmin

29. October 2013 SysAdmin 0

This is how you can reset the password of your wordpress admin user.

– Connect to your wordpress database via phpmyadmin or mysql-clients like sqlyog
– Select the database and get ready to run the following query.


UPDATE `wp_users` SET `user_pass` = MD5( ‘newpassword’ ) WHERE `wp_users`.`user_login` = “admin”;


Now you can login to the with username **admin** and password **newpassword**
– Of course, You can change the **newpassword** to anything on the mysql query to as you like .

Like and share if found helpful ![:)](


0 0 votes
Article Rating

Notify of
Inline Feedbacks
View all comments