Installing wordpress in localhost is an effective way for developing wordpress powered website. It saves time for not doing FTP just to test latest code update, but it will be a disaster if you forgot wordpress admin password and your system doesn’t have a mail transfer agent to deliver email.
Wordpress create a random admin password during its installation and you have to remember it (I never remember it, just copy and paste it) in order to login to wordpress dashboard. Wordpress will notify you to change the password once you are logged in.
If you suddenly forget the admin password, the easiest step is to use phpMyAdmin to create new password. I am using XAMPP so here are the steps to recover your wordpress password:
- Login to phpMyAdmin (eg: http://localhost/phpmyadmin) and enter your database username and password
- Point to your wordpress database and browse wordpress users table (tableprefix_users)

- Just click the edit icon for selected user to open the edit form
- Select MD5 function in user_pass field and enter new password for the user

- KlikĀ Go to update the field.
That’s all. Next time, better to keep your password memorable.
Posted in
Tags: 

I think we can do this trick for Real Server too. Thanks for share this tricks
Yes, but using forgot password link will save your time instead of opening phpMyAdmin.
What a great resource!
Super post, tienen que marcarlo en Digg
SuperSonic
this post will help me a lot for my work in college.
Terrific work! This is the type of information that should be shared around the web. Shame on the search engines for not positioning this post higher!
Thanks for this! Saved me from a re-installation!
Super post! Thank you, thank you …