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.

[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)

 


Leave a Reply

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