The MySQL database for WordPress stores all user passwords in the table wp_users. With phpMyAdmin, learn to generate new passwords for each user account in your WordPress installation. This is very useful in case of loss of password!
How to Reset Password in WordPress
We need to access phpMyAdmin account first. Which is just the tool for managing MySQL databases via a web browser.
Simply, it is a kind of Microsoft Access.
This module is accessible through your web host, your cPanel or Plesk platform. Refer to the documentation for your provider for details.
Once logged on to phpMyAdmin, locate the table wp_users (usually from the left column.)
Click ”show user accounts” (or equivalent) to see the entire user list on your WordPress site. in the user_login column, identify the user whose password should be changed then click the pencil or edit icon to edit it.
In the User_pass field, enter your new password and then remember to select MD5 in the Function column. Confirm by clicking the Run or Save button (Will differ in name from platform to platform; but basically it is the same).
Your password is now reset and you will notice that it has been encrypted in the table of WordPress users.
Then return to your WordPress login page and enter the new login.
This example is to illustrate the advantage of knowing the method of resetting passwords directly from the MySQL database. By learning this way you will re-gain Admin right in case of hijacked site.