How to reset WordPress password at Localhost

In this article I will explain steps to  Recover WordPress Admin password at localhost via phpMyAdmin Interface.
Resetting password at live server of WordPress Self hosted blogs/websites are easy.

What if you forget password of a localhost installation?
To reset password at localhost some manual work needed to be done. 

reset WordPress password wpgyan 1

On localhost installations WordPress Reset password function don’t send a reset e-mail to your e-mail.Since most default localhost server install has not configured to send a e-mail.

 

reset_wordpress_password_wpgyan_2

So, How to deal with it?

Follow these steps to recover Lost Password.

1. Log In to phpMyAdmin Panel

Browse to http://localhost/phpmyadmin/ and enter your Mysql user name and password and click on “Go”.

reset_wordpress_password_wpgyan_3

2. Select the database of WordPress installation

Choose the database of WordPress installation which password need to recover.
if you don’t remember database name then go file directory of WordPress install and look for

in wp-config.php file.In my case database name is ‘wpdir’.

reset_wordpress_password_wpgyan_4

3. Select wp_users Table

In my case prefix is wp_  you may have different prefix. But table name will be yourprefix_users.

reset_wordpress_password_wpgyan_5

Once clicked on users table a list of users will show.Click on ‘Edit’ link of the user whose password you want to reset.
In My case it is ‘Gyanendra’.

reset_wordpress_password_wpgyan_6

4. Change the Password

Once you will click on wp_users table you will see the table structure as show in the picture below.
reset_wordpress_password_wpgyan_7

 

  • a.In user_pass  column select md5 in drowdown.
  • b. Enter the password of your choice in corresponding value field.
  • c. Click on ‘Go’  to save the settings.

Once done browse admin section of your WP website and enter username and password you just changed.
You should be able to Login!

Feel free to comment below or ask question :)

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">