How to Reset wordpress admin password via MySQL query or PhpMyadmin

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.

[sociallocker]

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

[/sociallocker]

Now you can login to the http://yoursite.com/wp-admin 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 ![:)](https://www.jobnix.in/wp-includes/images/smilies/icon_smile.gif)

 

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
Scroll to Top