Reset your local wordpress password easily

Published on December 30, 2006 .8 Comments

While building my theme I installed wordpress with lots of sample data and I realized I forgot my password and couldn’t recover it even with a “forgot password” link. So after playing around for 30 mins, I reset my password. This is how.

start mysql and login
SELECT ‘wordpress’ //this should be your database name
UPDATE wp_users SET user_pass = MD5( ‘password’ ) WHERE ID =1 LIMIT 1 ;

where password is your new password. Your password is reset, for the admin acount.
Enjoy

8 Responses to “Reset your local wordpress password easily”

Feed for this Entry Trackback Address

Leave a Reply