How to recover Wordpress password at localhost

Today I faced a weird problem, I have a local installation of Wordpress for some testing purpose. I am using wamp as a linux, apache, mysql, PHP bundle on my windows7 ultimate, today when I tried to login my local Wordpress installation using admin the password was not working, simply I forgot the password.

For localhost, I have not configured any smtp mail server so I can’t recover my Wordpress admin password by clicking on “forget password”. The only method visible to reset is using mysql database. So here I am listing the same step by step method for rcanblog users.

I have wamp server installed, so I have phpmyadmin also.

1. Start phpmyadmin in your web browser, it should be something like http://localhost/phpmyadmin, login to it.
2. In left hand side of your phpmyadmin welcome window, you will be having all the database, click on your Wordpress database.
3. It will list all your wordpress tables, then you will find a table name ‘wp_users’, this is the one which stores all the user info. Click to browse this table.
4. Then it will list all the entries of ‘wp_users’ table. Now click and edit user named ‘admin’.
5. There is a field called ‘user_pass’, it has your password, but you see this is in encrypted format, Wordpress uses MD5 encryption algorithm function.
6. Now change the column ‘Value‘ of user_pass filed with your desired password, Note : select the function MD5 in ‘Function‘ column.

Here we go, you have successfully changed your Wordpress admin password. This method can also be used if you have any problem with your email on your Wordpress self hosted site. This post may be bit techie as I am assuming that you have a basic knowledge of php and mysql. If not just leave a comment below, I will try to suggest you in some more friendlier way.

You can also comment if you are not having ‘phpmyadmin’ or for anyother queries.