Jan. 13, 2015 - BobWP
https://bobwp.com/resetting-wordpress-password-not-emailed/ Log Into Your Hosting Account You are going to log into your hosting account and find that little bugger called phpMyAdmin. It may be easy to find or in your cPanel under Databases. Now you will land in the bowels your database. Over on the left will be all your WordPress installs. If you have more than one, you will need to figure out which one it is. In this next step we are killing two birds with one stone. Click on one of those databases. In this instance, there is just one that starts with wp. You will get a page similar to this, although you might even have more stuff. What we are looking for is wp_users. Click on that. Once you get a list of all your users, track down your name (in this example we are looking for Joe Smith) and click on the edit button by it. You will also see in the above screenshot the user_nicename as well. So if you forgot your user name to, here is your chance to get it. But you will see that the password is encrypted so there is no way to decipher it. You will need to change it. Once we click the edit button, we get this screen. We want to do something very specific. Where it says user_pass, click on the drop down menu under Function and choose MD5. Put your new password in the box next to that. Remember to copy that password down! Then click Go. Now you should be able to login with your new password.