Usually, you can change Your WordPress Password in the control panel or request a new one by email. If you don’t have access to both your email and WordPress dashboard, you can change your password directly in the database.
Why Reset WordPress Password from phpMyAdmin?
WordPress makes recovering a lost password very easy. You can go to the login screen of your WordPress website and click on the ‘Lost your password?’ link.
When you click on the link you will be taken to the password reset page. After you enter your username or email address, WordPress will send a password reset link to the corresponding email address.
However, if you don’t have access to that email address, or your WordPress site fails to send an email, then you won’t be able to reset your password.
In such a situation, you will need to reset your WordPress password directly in the database. The easiest way to do that is to use phpMyAdmin.
How to Change WordPress Password from PhpMyAdmin Database
- Access your database in phpMyAdmin
- First, you need to login into the cPanel dashboard of your WordPress hosting account.
- Next, you need to navigate to the Databases section where you can click on the phpMyAdmin icon.
- Open the users table
- Now, select your WordPress database and you will see the list of tables in your WordPress database. You should search for the wp_users table in this list and click the Browse link next to it.
- You will now see rows in your WordPress users table. Click the Edit button next to the username you wish to change the password for.
Note: Table names in your WordPress database may have a different prefix than the one we show in our screenshot. Changing table prefixes can improve the security of your WordPress site.
- Enter new password
- Select MD5 from the drop-down menu under Function next to user_pass.
- Under Value replace the current encrypted password with the new password. You can type in plain text, which will be encrypted after saving.
- Click Go to save your changes.
- You are done!
- Your new password is saved and encrypted. It can now be used to login into WordPress.
