What do you do when you’ve lost your Admin password and the  php_mail() ain’t working? Why, you just manually change your password in the DB. But how do ya do that, Curt? You can’t just pull up phpmyadmin and look because the password is encrypted… it’s a bunch of gibberish. It’ll take your crappy Amiga about 30 years to crack that password. Here’s the easy way, run this query in phpmyadmin:

UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here‘ ) WHERE `wp_users`.`user_login` = “admin_username“;

There. now you should be able to log into your back end!

Original Article