How to: Manually reset your WordPress password

February 13, 2009 at 8:01 am

What to do if you lost your WordPress password? The easier is to use PhpMyAdmin and execute a simple SQL query to update it. Here’s how to proceed.

To achieve this recipe, login to your PhpMyAdmin, select your WordPress database and click on the “SQL” button to open the SQL query window.

Then, paste the following code in the window textarea. Don’t forget to modify the password and username before executing it. Also, make sure you have a backup of your database before executing any SQL queries to your database.

UPDATE 'wp_users' SET 'user_pass' = MD5('PASSWORD') WHERE 'user_login' ='admin' LIMIT 1;

CRedits goes to Ditii for this awesome recipe!