Reset WordPress Admin or Users Password Via MySQL Queries
If you are managing more blogs or websites based on the WordPress CMS, you might have chance to lost password. WordPress Admin and all users password will be stored on the wordpress database. Here is the step by step procedure will help you to reset the password of Admin or any users password from database.
If you are managing dozen of blogs, it is diffcult to keep in mind about name of database which is used by particular WordPress site that you have lost admin password. it is a simple to find database of particular WordPress site, login to cpanel and visit the root directory of WordPress and open the wp-config.php file with text editor, this fill will give you the database details of WordPress site.
All hosting provider give you that access to phpMyadmin interface to manage the database that is used by your websites, phpMyAdmin can be accessed via cpanel. phpMyadmin might be under the Database section in cpanel. Click on the phpMyAdmin icon and get access to it.
Once phpMyadmin is opened, Select your database which is used by WordPress. Open the SQL tab in top navigation bar.
Enter the following code in the SQL query box and click on OK.
The folloeing command contains password in plain text,
UPDATE `wp_users` SET `user_pass` = MD5( '123456' ) WHERE `wp_users`.`user_login` = "admin";
The following command is equivalent to above with MD5 encrypted password.
UPDATE `wp_users` SET `user_pass` = 'e10adc3949ba59abbe56e057f20f883e' WHERE `wp_users`.`user_login` = "admin";
123456 –> Replace this with the new password you wish to use in plain text format.
e10adc3949ba59abbe56e057f20f883e –> Replace this with the new password you wish to use in MD5 format.
admin –> Replace this with the username the password should be updated for.
That’s all!. Now you can login as admin or with any user name with new password. Here is the another way Reset admin password using phpMyAdmin. Start blogging.