In this post, I will be showing you how to reset WordPress admin password via your hosting phpMyAdmin page. Please note that this procedure is for those who may have lost their WordPress admin password and also do not have access to the email address that was was registered with it. Before you proceed to reset the admin password, you must have full access to the WordPress database backend.
If you do know and have access to the email account that is linked to the admin account, then all you need to do is simply click the “Lost your password” option and the new password would be sent to the registered email account. If this is not the case, then proceed with the reset below.
Reset WordPress Admin Password via phpMyAdmin
Please note that I am using Godaddy but the procedure is same with all cPanel dashboard
- First log into your hosting cPanel account dashboard > Click on phpMyAdmin under the Databases section
- On the left pane, you will see list of databases. Locate your WordPress database, expand it and scroll down to where you have “wp_users”
- Click on “wp_users” > on the right pane you will see a list of account if you have more than one login account. Find the admin user name under “user_login” column > then click on Edit against the account
- Next locate “user_pass” under the ID column > click the drop-down in front and select “MD5” > then enter the new password under the Null Value column. Then click the Go button to save changes
- At this stage, your password would have been encrypted using the MD5 hash and then stored in the database
Now you have successfully changed your WordPress password via your hosting cPanel using phpMyAdmin.