Techie Tips WordPress

How to Reset WordPress Admin Password via phpMyAdmin

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.

Also for those who may not know this, phpMyAdmin is a free software tool that was written in PHP, hence allowing you to administer admin tasks on MySQL database over the Web.

Reset WordPress Admin Password

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
READ  Top Ubuntu Apps Recommended for 2017

Reset WordPress Admin Password

  • 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”

Reset WordPress Admin Password

  • 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

Reset WordPress Admin Password

  • 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

Reset WordPress Admin Password

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

About the author

Admin

A passionate Linux and Open Source user. In my spare time, I love developing mobile games for fun (You can check my games out iOS Store | Google Play Store) and also spend time contributing to the Linux community.

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz