How to Reset Your WordPress Password with cPanel and phpMyAdmin
In this Quick Guide, we’ll walk you through how to reset a WordPress user’s password using cPanel and phpMyAdmin. To change WordPress passwords from cPanel is simple (it takes less than a minute front-to-back) and it’s a very useful trick to know—one we use at least a couple times every single month in our work with our clients.
Why Changing WordPress Passwords from cPanel is Useful
Why would you want to know how to do this? There are at least three relatively common situations where you find yourself with cPanel access to a site, but not WordPress admin access. They are:
- The admin user is registered to an email address (such as a previous developer) that your client no longer controls.
- Your client has lost the admin user’s password, and the “Lost your password?” emails aren’t sending correctly because of a server mail configuration problem.
- Your client can’t remember the admin user’s username.
In each case, you need to access the WordPress database directly—most commonly with cPanel and phpMyAdmin. Here’s how to do it.
How to Change WordPress Passwords from cPanel
Resetting WordPress passwords from cPanel is quite simple. You’ll need to make sure you have:
- Hosting that’s running the cPanel software itself.
- The phpMyAdmin program within cPanel to view and manage your WordPress database.
- The password to the hosting account.
If you’ve got those, here are the steps to change WordPress user passwords from cPanel:
- Log into your hosting account. (The screenshots below use InMotion.)
- Select cPanel from within your hosting interface.
- Once you’re in your cPanel, scroll down to Databases and select phpMyAdmin.
- Select Databases from the top and open your WordPress database. (This might get weird if you have multiple sites. If you doubt which database is the right one, your
wp-config.phpfile will tell you for sure.)
- Once all the tables in the database appear, look for
wp_usersand select Browse.
- Once you’ve found the user you want to edit the password for, select Edit or the pencil icon by their name.
- Select and delete the long list of numbers and letters next to
user_pass. (This was your old, securely stored, password.)
- Type in your new password. (Don’t forget it’s case-sensitive.)
- Click on the dropdown menu on the same line and select MD5. This’ll run the MD5 hashing algorithm on the value we just typed, making it into one that WordPress can work with. Hashing functions are a core part of how passwords are stored securely. David wrote a longer post about that, if you’re interested.
- Click Go on the bottom right of the screen.
- Go back to your site’s login page and log in.
And that’s how to change a WordPress password in cPanel! Easy, right? Thanks for reading, and let us know if you’ve got any questions about your particular situation.
Image credit: Paulius Dragunas