How To: Recover Wordpress Password Part II
6 Comments April 10, 2007 3143 Views
In part I of this series, I showed you how to recover your Wordpress password using the MySQL command line. This time, I’ll show you how to do it with phpMyAdmin.
Before you start with phpMyAdmin, you need to create a md5 hash of your new password. You can use iWebTool’s md5 Encrypt. After you created the new md5 hash, save it and kept it for later.
Note: use phpMyAdmin at your own risk. If you are not sure on how to use it, seek further advice. I’m not responsible for any loss of data.
1. Open phpMyAdmin.
2. Click on the drop down menu and select your Wordpress database.
3. From the list of tables, look for the wp_users table and click on the Browse icon. (the prefix may defer with different databases)
4. Click on the Edit icon (pen icon).
5. Look for the md5 hash of user_pass under the Value column.
6. Change the md5 hash with the one you created earlier. If you want to use a different username, you may also change the present value with a new one.
7. Close phpMyAdmin
8. Login to your Wordpress blog with your new password (and username if you changed it).
I hope this series would provide you with the needed information when you experience this issue. Some of you might know a totally different way of doing this. Suggestions and corrections would be greatly appreciated.
(3 votes, average: 5 out of 5)
Loading ...
Hello and welcome to JaypeeOnline! My name is Jaypee Habaradas and I'm the author of this blog that talks about the latest blogging news, WordPress theme and plugin reviews, technology, gadgets and tips & tricks.
Nice tutorial dude. Using phpMyAdmin is not that tough. You just have to read and read twice before you click on anything.
@jhay - Thanks man! Just trying my best to provide useful information to Wordpress users out there. Yeah, phpMyAdmin is not that difficult to use but if you don’t know what you’re doing, you can do a lot of damage to your database. Hehe
Hi Jay,
You can always use the MD5 function in the dropdown menu in the function column. This way you can just provide the plain text password and mysql will generate the hash for you.
@kates - Thanks for info. I’ve seen and read about that but I’ve never tried that before. Hehe I’ll edit this post later when I have the time.
@Henry - You’re welcome and good to know that it helped you!