How to Change WordPress Password in phpMyAdmin (a cPanel tool)

wordpress change password cpanel

In this Quick Guide, we’ll walk you through how to change a WordPress user’s password using phpMyAdmin, a tool found in most webhosting cPanels. To change WordPress passwords from phpMyAdmin 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:

  1. The admin user is registered to an email address (such as a previous developer) that your client no longer controls.
  2. 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.
  3. 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 you’ll quickly be able to change WP passwords in phpMyAdmin.

Video: How To Change Password for WordPress in phpMyAdmin

In this video, I walk you through how to reset WordPress passwords using phpMyAdmin, or a similar database administration tool. The core things are: using MD5 as a database-level function, and resetting your WordPresa admin account’s password again after you’ve gotten into it from phpMyAdmin.

How to Change WordPress Passwords from phpMyAdmin

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:

  1. Log into your hosting account. (The screenshots below use InMotion. Our latest thoughts on the best WordPress cPanel hosting are here.)
  2. Select cPanel from within your hosting interface.1
  3. Once you’re in your cPanel, scroll down to Databases and select phpMyAdmin.
  4. 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.php file will tell you for sure.)
  5. Once all the tables in the database appear, look for wp_users and select Browse.
  6. Once you’ve found the user you want to edit the password for, select Edit or the pencil icon by their name.
  7. Select and delete the long list of numbers and letters next to user_pass. (This was your old, securely stored, password.)
  8. Type in your new password. (Don’t forget it’s case-sensitive.)
  9. 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.
  10. Click Go on the bottom right of the screen.
  11. Go back to your site’s login page and log in.

And that’s how to reset a WordPress admin password phpMyAdmin!

Image credit: Paulius Dragunas


14 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
J shadow
April 23, 2023 12:12 pm

Thanks, it helped!

Manjeet
February 12, 2022 7:39 am

This is very informative. I just forgot my site password and wondered what it was. This is an easy way to reset password and we can see it anytime from phpmyadmin. Great content.

Fred Douglas
December 10, 2021 5:30 am

I am just amazed that this solution still working in 2021. Hats off to David!

Tuba
June 27, 2021 12:21 pm

THANK YOU SO MUCH!!!!

Sam Roberts
October 8, 2020 8:04 am

Amazing, complete lifesaver today!

Robert Pope
August 3, 2019 12:32 pm

Thank you. So easy.

Miles
February 25, 2019 5:01 am

Lifesaver! Thank you.

Tania
February 19, 2019 5:03 pm

What if there isn’t a wp_ under the database? Does that mean WP isn’t used to design the site?

Anudeep Syamprasad
October 16, 2018 6:17 am

Straight answer to my problem. Thank you.

Louis
June 18, 2018 12:28 am

Thank you Harper. This helped me a lot!

waiguru
February 28, 2018 11:18 am

Perfect. IT WORKED

MySQL Basics: Writing Custom SELECT Statements in phpMyAdmin | WPShout
May 31, 2016 11:32 am

[…] In the image above, we’re viewing the posts table of a WordPress site’s database. You’ve likely browsed through phpMyAdmin to, for example, manually reset a user’s password. […]

Rosca Bogdan
November 5, 2015 9:46 am

Your passwords are md5 crypted, it`s true, but they are crypted with a salt key (from your config.php file) in order to be more secure. Only changing from there (cPanel) is a little bit risky.