I’ve found this method today, and it works very well. I’ve just used it to reset my admin access password to a localhost installation. In fact it’s impossible to recover a password by means of an email if your system cannot send emails. This method is also very easy, and without email delivery delays in between.
- Open phpMyAdmin (a different MySQL web access tool should be fine, too)
- You should see the welcome page. Find the Database selection box and select your WordPress database
- You should see a list of tables, many with a common prefix, organized as links on the left and as rows on the right. Click the link wp_users (instead of wp you’ll use the prefix you chose when installing WordPress, if different)
- You should see the wp_users table structure, but you’re looking for its contents, so find the Browse link and click it
- You shoud see the wp_users table contents, one row for each registered user. Select the one with the admin value under the user_login column header and click on the Change link (with a pen icon, right below the last row)
- You should see a classical data entry form. In the row which has the user_pass value under the Field column header, select the MD5 value from the selection box under the Function column header, and write your new password in the text field under the Value column header. Then click Go
- Close phpMyAdmin
- Done
Wow, this one is really cool! I tried and certainly it worked so well!
Thanks for the post!
It is very useful
Thanks man! you saved me 🙂
May the force be with you!
Well, thsi method really beats the old one I’ve been using by opening a mysql console connection and working with that. Thanks for the great tip.
wow this saved me mine i forgot my password and then got it back
First class chap.
OMG dude you have just solved a problem that has stressed me out SO MUCH!!!! Thank you.
Hey,
You just saved me alot of time !
Thanks 🙂
wow.. this is very useful.. you just saved my time.. thanks..
Brilliant tip – thanks for that mate!
I love you.
Thanks for the post, works Super!!
This is really cool and simple way that worked for me and took just a few seconds for me. Thank you!