How to Reset a WordPress Password from Control Panel
To know how to reset your WordPress password from phpMyAdmin is one of the essential things you should know about because for some reason if your site is hacked, or you are no longer able to login to your admin panel using the login information, and you are not able to reset the password via email, this method can be very useful. Every WordPress blog uses a MySQL Database which can be accessed through your phpMyAdmin.
Follow the following steps to reset your WordPress password:
STEP 1 – IDENTIFY THE NAME OF YOUR DATABASE
It is always good to know the name of your WordPress Database. Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password. The best place to look is your wp-config.php file which is located in your root WordPress Directory. In there you will find the name of your database.
STEP 2 – LOCATING DATABASE AND EDITING THE FIELDS
In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.
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 see a list of tables with a prefix wp_ for the most part.
If you changed your prefix during installation, then you would be looking for that specific prefix “for ex: wp673_”.
You will look for the table wp_users, click on.
Click on the Pencil (Edit) Icon to reset your Password.
Now you will see a field that looks like this:
Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text.
You will enter your password in plain text and then select MD5 option from the field opposite it and click Go to save changes.
You have now successfully changed your WordPress Password from phpMyAdmin.