How to Reset a WordPress Password from phpMyAdmin

Last Updated on January 16, 2021 

The importance of knowing how to reset a WordPress password from phpMyAdmin is one of the most important things you need to know when starting your WordPress site. If your site happens to get hacked, or something else, you will no longer be able to login to your admin panel using your login information, and you will not be able to reset the password via email if your credentials have been compromised. In this post, we are going to show you how to reset a WordPress password from phpMyAdmin.

Every single site that is created using WordPress uses a MySQL Database. It can be accessed via your phpMyAdmin even if you aren’t using cPanel hosting. The below steps will easily guide you so you can reset your WordPress password.

Pin Image To Pinterest

how-to-reset-a-wordpress-password-from-phpmyadmin

 

Video Tutorial: How To Reset A WordPress Password From PHPMYADMIN

How To Reset A WordPress Password From PHPMYADMIN

Step 1 – You want to Identify the Name of your Database

It’s so important to always know the name of your WordPress Database. Create a text document or write it down so you always have it in case something happens and you need to reset your WordPress password. You might find your self-running multiple installations within the same database. If this is the case to need to know where to look when resetting the password for your WordPress site. One of the best places to look is going to be your wp-config.php file which you can find in your root WordPress Directory. In this root WordPress Directory, you will locate the name of your database.

Step 2 – Locating Database and Editing the Fields

You want login into your cPanel or another admin panel, you will need to access your MySQL database, and then you want to browse it using phpMyAdmin.

 

php-my-admin-example

 

Once you are in phpMyAdmin, you will need to select the correct database on the left-hand side. Look for the name that you found in your wp-config.php and click on that. You will now see a list of tables with a prefix wp_ for the majority of the list.

 

database-name

 

If you happened to change your prefix during your WordPress installation, then you want to look for the specific prefix that you had changed it too. An example is “wp359_”.

You want to look for the table wp_users.

 

wp-users-table

 

Once you find it click on it and then you want to click on Browse Tab.

 

resetting-wordpress-password

 

You now want to click on the Pencil (Edit) Icon so you can reset your WordPress Password.

 

edit-wordpress-password

 

You’re going to see a field that looks like this:

 

user-password-field-value

 

You now want to edit the user_pass field value. You are going to notice there is a lot of random characters showing in the password field. The reason for this is due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text. Because of this, you won’t be able to enter plain text as the password. You are going to have to use one of the MD5 generators online to generate your WordPress password.

We recommended you using this tool when doing this: JavaScript MD5

Using this tool you want to type in your password and generate the MD5 results. Once it is done you want to Copy and paste the code received from the converter into your phpMyAdmin field and click Go to save changes.

You have now changed your WordPress Password from phpMyAdmin.

Final Thoughts

We hope this article helped you and showed you how to reset a WordPress password from phpMyAdmin.

Let us know in the comments below if this was helpful! We would love to hear from you.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *