This post is for all the dumbasses out there who, like me, have managed to forget their Wordpress site login and email address at the same time.
If you forget your password you can get it back by entering your email. But if you are foolish enough to forget both the username and email address, you’re in for trouble. Ok you’re not, because in this post I’m going to show you exactly how you can retrieve/change your username, password and email address from your MySQL database.
You’ll need phpMyAdmin for this - you have it if your host has provided you with either cPanel or Direct Admin. Here are step by step instructions on how to recover your username/password/email address from the database:
1. Login to your cPanel and look for phpMyAdmin - you might have to click on the ‘databases’ icon to find it.
2. Once you’re in, select the database for the blog/site in question from the sidebar.
3. Click on the browse button for the wp_users table. (see image below)
3. Now click on the edit button (pencil) for the required username. This step also gives you your username if you’re like me and have been stupid enough to forget it.
4. You’re almost there now. In this form, you can change your username and password. This is what you’ll see:
Don’t worry, the Value in the user_pass field is not your password - just an encrypted version of it.
5. Change the password string to whatever you want. Now from the function drop down menu, select “MD5″. The image below makes it clear.
6. Click on ‘Go’ and you’re done 
That shouldn’t take more than 5 minutes, did it?
