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!
If you enjoyed this article, please consider sharing it!
Related Posts
Related Posts
No related posts.Leave a Comment
- Voosh Themessave 20% on your purchase […]
- Magic MembersSave $15 on your purchase […]
- Page.lySave 20% on hosting […]
- WordPress Rating pluginSave $15 on your purchase […]
- WpZoom – Yamidoo Themesave 30% on your purchase […]
- Neatothemesget 20% off every theme […]
- WordPress Defendersave $4 on your purchase […]
- Templaticsave 20% on your purchase […]
- Squeeze Themeget 25% off your order […]
- Canvas ThemeGet 25% off the Canvas theme […]
Copyright © 2008 - 2010 WordPress Development by Jean-Baptiste Jung. Graphic art by GreenBubbles.org.ua, all right reserved.
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: