If you’re planning to reset your WordPress password using phpMyAdmin and looking for a way to make this happen, you’re in the right post, fortunately.
No worries if you can’t reset your WordPress password because you can easily reset it from your WordPress database using phpMyAdmin. The process of retrieving the password in WordPress using phpMyAdmin is super easy.
In this post, we’ll let you know how you can easily reset your password using phpMyAdmin.
If you forgot your WordPress log-in password, you don’t need to be worried at all. Fortunately, WordPress makes it easy to reset a forgotten password. The easiest way to recover your password is simply to log into your WordPress account and click the ‘Lost your password?’ link.
A password reset page appears after clicking on the link. The password reset link will be sent to the email address associated with your username or email address once you enter your username or email address.
It is impossible to reset your password if you do not have access to that email address or if your WordPress site fails to send a password reset email. So when the email procedure does not work, you need to switch to the following procedure.
It is necessary to reset the WordPress password directly in the database in such a situation. One of the easiest ways to do this is through phpMyAdmin.
So let’s take a look at how easy it is to reset your WordPress password via phpMyAdmin.
Sign in to your WordPress hosting account using the cPanel dashboard. To access phpMyAdmin, click on the icon in the Databases section.
You’ll be prompted to choose your WordPress database in phpMyAdmin once you click that button.
Your WordPress database will now display a list of tables. Click on the Browse link next to wp_users in this list to view the wp_users table.
N.B: There may be a difference in the prefix of your MySQL database table names compared to the example we are showing. Changing the table prefix can make your WordPress site more secure.
Now you’ll be able to see all the users on your site. You can change the password for the username by clicking on the Edit button next to it.
You’ll see a form that contains all the user information fields in PHPMyAdmin.
You need to replace user_pass with your new password and then delete the value in that field. Click the Go button at the bottom of the form after selecting MD5 in the function column.
Passwords are encrypted with the MD5 hash and stored in a database.
Congrats! By changing your WordPress password in phpMyAdmin, you have done it successfully.
There may be some who wonder why we selected MD5 as the encryption method. In WordPress 2.0, passwords were encrypted using an MD5 hash, but since WordPress 2.5, stronger encryption technologies have been used.
Although MD5 is still recognized, it only provides backward compatibility. Within seconds of you logging in with an MD5 hash stored as a password string, WordPress will automatically change those algorithms to the newer ones.
Well, it’s a wrap; we hope the post helped you learn how you can reset your WordPress password using phpMyAdmin. You may want to see our guide on regenerating permalinks in WordPress. You may also want to see the list of 13+ signs that your WordPress is hacked and how you can fix them.