Sometime ─you forgot your administrator password and you don’t even remember the registered email. If you are developing the website using WordPress application that is running on localhost and forget its admin password. Under these scenarios don’t need to waste your time by trying wrong password again and again. All you need to follow below steps and get reset your wordpress admin password using PhpMyAdmin. Using the same method you can also reset any of the registered user’s password.
Reset WordPress Admin Password using PhpMyAdmin/Mysql
This is the only way to reset your wordpress admin password from your mysql database that resides under PhpMyAdmin.
Please note: Do not try by yourself if you are not developer and/or don’t feel comfortable while doing this. I suggest you to get help from expert.
Steps 1: Login to your CPanel dashboard.
Step 2: Click on phpmyadmin link that is located under Database tab as shown in image below.
Step 3: Look for “wp_users” table and click on it to open. “wp_users” table is used to store all registered accounts for your WordPress application. “wp” is the prefix used for safety purpose and was given at the time of installation.
Your database will be located on the left side. Click on it to explore all tables. If there are more than one databases in the list, then go in to your wp-config.php file and find your database name there.
Step 4: Now Click on EDIT button from the table records of your desired admin account. Make sure that you have clicked on correct Edit button in case of many user accounts.
Step 5: Now the EDIT Form is on the screen. Under the “columns” heading look for “user_pass”, Select MD5 from function dropdown and enter new password in value textbox. Then Click on Go button located at the end of the EDIT Form. (See image below)
You have done updation of your account for your forgotten password with User interface. Now go to your wordpress login page and enter your updated credentials.
You can also reset your forgotten password using SQL Statement through PhpMyAdmin. This way of resetting password will works if you have correct “username” with you. Simply run the following from the SQL tab. Update parameters “update_password” with the value that you want to set now for your account and “your_username” values that already have with you.
UPDATE `wp_users` SET `user_pass` = MD5( ‘update_password‘ ) WHERE `wp_users`.`user_login` = “your_username“;
Hope this helps!