I got a question on Email which asked me can you reset your WordPress password using phpMyAdmin or not? I am personally not answering his question but am creating this article which will show you how easy it is to reset a WordPress password from phpMyAdmin.
Why Reset WordPress Password from phpMyAdmin ?
There are number of reasons why you would have to reset your WordPress password using phpMyAdmin and they are
- no phpmail support by server
- mail socket blocked on server
- you put wrong email while registering
If none of the case applies to you then resetting a WordPress password is super easy, you simply go to login screen and click Lost your Password Link.
Next Screen is where you enter either username or email address. As soon as you click, you will receive a password reset link.
You can reset WordPress password this way easily, but if you are in the category mentioned above where you are unable to get an email or entered the wrong email then the easiest way is to reset WordPress password using phpMyAdmin.
Also Read: Optimize your WordPress Website
How to WordPress Password From PhpMyAdmin
If you are using a cPanel hosting account then open up your phpmyAdmin panel in databases section.
This will launch your phpMyAdmin application where you will have to select the database of WordPress installation in case you have multiple installations on your cpanel account. Select the right database from the right hand side in phpMyAdmin.
As you select the right databse, you will see the list of database tables in that WordPress Database. The user database typically resides in wp_users table in case the default WordPress table prefix is not modified.
This website does not have the default table structure as I have modified the WordPress table Prefix.
As you can see the modified WordPress table prefix is wpcu_users in the above image. Click on the Browse link next to it.
As soon as you click the Browse link, phpMyAdmin will show you list of WordPress users in a table. You will have to click the Edit Link which has a pencil on it’s left side for the user you want to modify password.
When you click the Edit Link phpMyAdmin will then show you a form with user information.
This is the place where you have to enter your WordPress Password in the user_pass field.
Please note that we have selected MD5 as the function in the dropdown because WordPress used MD5 hash to encrypt passwords until version 2.5. Your password will be saved as MD5 hash initially but eventually be converted into the new encrypted function as soon as you log in to your WordPress dashboard once.
Congratulations! You have reset your WordPress Log in password using phpMyAdmin.
Resetting your WordPress password is very easy but for those who are unable to get the emails, this becomes headache. Either they will have to re-install their WordPress again or try any other methods.
Resetting WordPress password using phpMyAdmin is one of the easiest methods to reset your WordPress log in password and it takes less than 5 minutes in total. You can even change your email address using the same process.
If you liked this article, please share this to anyone who is in need of resetting their WordPress log in information and are unable to do so.