How to Reset a WordPress Password from phpMyAdmin
If you find that you are unable to reset your WordPress password using the ‘Lost my Password’ option on the login screen, then there is another way to reset it from within your WordPress database using phpMyAdmin.
First off, you will need to head to the phpMyAdmin icon that is displayed under the database section on your Cpanel dashboard. Access the Cpanel by logging into your WordPress Hosting account.
This will now launch the phpMyAdmin app. Down the left-hand side, select your WordPress database.
Clicking this will display a list of all the tables in your WordPress database. You want to select the table that is named ‘(table prefix)_users’. Once you have found this, click ‘browse’ next to it.
You will now be shown the rows within the WordPress users table. You should be able to see the usernames of all the users who possess a login for your WordPress account. By clicking the ‘edit’ button next to a users username, you will be able to edit the password for that account.
Upon clicking edit, you will need to delete the value in the ‘user_pass’ field and replace it with your new password. Under the function column, select ‘MD5’ from the drop-down menu and click the ‘Go’ button.
By selecting ‘MD5’ your password will be encrypted using the MD5 hash and stored in the database. It’s as easy as that!