How to change WordPress Password from phpMyAdmin?

Do you want to change your WordPress password from phpMyAdmin? If you are forget your WP Admin password and want to reset it, then there is a option to reset it in your WordPress database by using phpMyAdmin. In this article, we will tell you how the Password of WordPress can be changed by login in to the cpanel and using phpMyAdmin.

Why do you want to Change WordPress Password from phpMyAdmin?

WordPress makes more easy to reset your password. You can just go to the login page and click on the ‘Lost your password’ link.

When you click on it takes you to password reset page where you can write down your user name or email address to change the password. WordPress sends you a password reset link to the email address included with that user account. But, if you don’t have detail to access the email address, or your website failure to send an email, then you will not be eligible to reset your password.

At such a time, you have to changes your WordPress password directly into your database. You can easily change the password using the phpMyAdmin.

See below step to how you can easily change your WordPress password from phpMyAdmin.

First, you will require to login to the cPanel of your WordPress hosting account. Click on the phpMyAdmin icon link under the database section. After this, phpMyAdmin page open where you require to select your WordPress site database.

phpMyAdmin-under-database

Now can see the list of tables in your WordPress website database. Here you require to click on ‘{table-prefix}_users’ (wp_users). You can see the users row table and click on the edit button where you want to change the password.

database-table-selection

Now see a form with all the user information fields. You will need to erase the value in the user_pass field row and replace it with your new password. Select MD5 from the drop down under the function column and click on the Go button. Your password is encrypted by using MD5 hash and then it is stored in the database.

reset-password

Congratulation friends! You have successfully changed your WordPress website password by using phpMyAdmin.

4 thoughts on “How to change WordPress Password from phpMyAdmin?”

Leave a Comment