Reset WordPress Admin Password Using Phpmyadmin

If you forget or unable to login your wordpress admin panel then don’t need to worry you can always reset your WordPress password, from your WordPress database using phpMyAdmin. In this article, we will show you how to reset a WordPress password from phpMyAdmin step by step. Follow the following step or watch the video.

 

 

How to Reset WordPress Password From PhpMyAdmin

1. First you need to login to Cpanel using your hosting account.

2. Next find phpMyAdmin icon under database section and launch it.

3. You will now see the list of tables in your WordPress database. You need to find the ‘{table-prefix}_users’ table in this list and click on the ‘Browse’ link next to it. Note table prefix by default is ‘wp’ during the installation of wordpress otherwise it will be what you set it.

4. PhpMyAdmin will show you a form with all the user information fields. You will need to delete the value in the user_pass because this field contains the old password, replace it with your new password. Under the function column, select MD5 from the drop down menu and click on the Go button.

5. Beside all that you can also do this work with a simple SQL Query. Copy and paste the following statement into the SQL query text box. Replace new_password with the new password, and replace admin_username with the administrator’s username.

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";

 

If you liked this article, then please subscribe or follow us. You can also find us on Facebook , Google Plus and Twitter or Download our APP.