How to Reset a WordPress Password with phpMyadmin
You would need to follow a few procedures in order to reset a WordPress password using phpMyAdmin. To change your password, you must first log in to PHPMyAdmin.
We’ll go into depth on how to carry out these straightforward activities in this post.
i. Access phpMyAdmin
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.
ii. Enter a New Password
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
Congratulations! Using phpMyAdmin, you were able to successfully change your WordPress password. So, with your new password, you may now access WordPress.
Why You Should Reset a WordPress Password
You might need to change your WordPress password for a number of reasons. Resetting your WordPress password is the only method to log back in if your website is ever hacked or you are unable to log in for some other reason.
You may reset a WordPress password for a specific account using a number of techniques. A WordPress password reset may be accomplished by FTP or, as described in this article, using the phpMyAdmin online interface. To reset a WordPress password quickly and regain access to your WordPress blog or website, simply follow the three simple steps in this WordPress admin advice.
Your password is saved in the database after being encrypted with the MD5 hash. Some of you, however, might be questioning why the MD5 hash was used to encrypt the password.
WordPress’s earlier iteration employed the MD5 hash to encrypt passwords. WordPress started utilising more advanced encryption methods with version 2.5. WordPress still accepts MD5 for backward compatibility, though.
WordPress detects password strings saved as MD5 hashes as soon as you log in and replaces them with newer encryption techniques.