How to Reset WordPress Admin Password
I have setup testing wordpress environment for my new blog. I like to customized wordpress theme on my computer rather than upload the whole thing to web host. Because it is faster and easier to customized.
As you know, wordpress supplied random admin password once setup finish. I copy and paste the password to login. But after that, I forgot to change to my own password. 
I have tried a lot common password to enter admin panel but failed.
Reset WordPress Admin Password
Since I have access to the local mysql database, I decide to reset the wordpress admin password manually. I used phpmyadmin to edit mysql database in graphic mode instead of command line.
Browse to the wordpress database, click on table wp_users. Click Browse then the admin details show up. Click on the pencil icon to edit admin details. In user_pass field, put in the MD5 hash code for your password.
Since the password field was encrypted with MD5 hash algorithm, you can’t simple put in the clear text. It won’t work. Goto MD5 hasher, key in your desire password and click OK to generate hashed string. Now, copy and paste your hashed password strings into user_pass field and click Go.
That’s all. Login your wordpress admin account with the new password. 
I hope next time I will remember to change the default password.
Comments
Comment from titanium_geek
Time December 14, 2008 at 11:13 AM
Wow, this was really helpful! I did it straight from the command line though:
mysql> use wordpress;
mysql> update wp_users set user_pass = REPLACE(user_pass,”[old hash here]“,”[new hash here]“);
and it worked! yay! thanks for the link to the MD5 hasher.
Comment from genxv
Time May 21, 2009 at 9:33 PM
Thanks! This worked perfectly using the MD5 hash. I was using this before to put in an encrypted password:
mysql> update wp_users set user_pass = password(‘thepassword’) where ID = theID;
It was driving me nuts when it didn’t work. But thanks to you the problem is solved with the MD5 hash.
Pingback from Wordpress Blog Hacked…
Time November 11, 2008 at 2:00 AM
[...] Re: WordPress Blog Hacked… Open up PHPMyAdmin via your control panel. Navigate to the users database, change the admin name and password. When saving the password, select MD5. You will have access to your WP folder again. More detail…How to Reset WordPress Admin Password [...]