WordPress: Reset your Password with phpMyAdmin
This article explains how to reset a lost WordPress password using phpMyAdmin.
It is highly recommended that you make a backup of your database before continuing. If you don't know how please read How to Backup a MySQL Database.
To perform this task you will need the following Items.
- The name of your WordPress database. If you aren't sure please see How to find your WordPress Database
- Your Bluehost cPanel username and password
These steps explain how to access phpMyAdmin.
- From your account cPanel, go to the databases group of icons, and click on phpMyAdmin
- When prompted login with your cPanel username and password.
- From the list of databases, select the database for your WordPress site.
These steps explain how to change the password in the database.
- In the table list, click on the users table
Note: In our example the table prefix is "wp_" the prefix varies from site to site so don't worry if yours is different.
- Click edit next to the user you want to set the password for.
- Enter the new password into the password box
- In the function box next to the password choose MD5
- Click Go
The password has been reset. You can now login to WordPress with your new password.