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.
- 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.