Why Reset Your Password in the Database?
Sometimes the password reset link at wp-login.php does not work as expected. Typically after entering the email address there is no confirmation that the password reset link has been emailed. In this scenario you can reset your password for your WordPress website from the backend, using phpMyAdmin.
Resetting Your Password via the Database
To do this, start by logging in to your User Portal. Once logged in, locate the environment for which you need to reset your password. Then select phpMyAdmin link from the left-hand navigation–this will take you into phpMyAdmin to manage the database for this environment.
In the phpMyAdmin you may see two databases. The one with the snapshot in the name of the 1-click staging area, and the other one with the wp in the name is the database for the standard environment area. Click on the database for the area you need to access.
Next you will see a list of tables starting with wp_ . Click on the wp_users table near the bottom.
The wp_users table contains all of the users assigned to your WordPress environment. Find the user for which you need to reset the password and click on the “Edit” link located in the user’s row.
The user_pass section contains the encrypted password for the selected user. Enter the new password in the Null Value column and then select MD5 in the Function section. Click Go at the bottom of the screen to save the new password.