
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.

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!
11 Responses
nice trick, thanks for sharing this
In WP 2.7.1 it seems like the password arent crypted with MD5, so I don’t think this will work. (Haven’t tried though).
Ronny, I want to say that I’ve tried it in 2.7.1 (fully expecting it to not work), but it did. I havent tested to be sure though
First thing I do after installing a new wordpress blog! If you need to install a large number of wordpress blogs you can change the default random password and set it to whatever you like although this message isn’t safe and because of that not recommended.
Not Working in WP 2.9
Trackbacks: