I was put in a situation where I had FTP access to this client’s WordPress site, and I had access to his database too via phpMyAdmin, but not the administrative credentials (username & password) for the site. As long as I had FTP access and a phpMyAdmin it took me a couple of minutes to gain access to the backsite. At this point I know what you are thinking – “Why don’t you use the WordPress feature where you can recover lost passwords”? I could not use that feature, because I did not have access to the mailbox where WordPress was going to send the information to. I had to resort to the following tactics:
1 – If You don’t have the credentials to the database – hostname, username, password, and database name, use your FTP client to download the wp-config.php file to your computer and open it with your favorite editor. Mine is Notepad++ btw… In this file you will find all the necessary info that you will need to edit the database.
2 – Now that we have the database credentials, launch phpMyAdmin and change the password. The table you will need to edit is the “users” table. Edit the user who is the site’s administrator. The field that holds the user’s password is encrypted, so when you change the password, change the field to MD5, and then save your changes.
If you don’t want to change the password, but just retrieve it, you can use a site like md5.gromweb.com where it can reverse engineer an MD5 encrypted passwords.
Here is a short video demonstrating how to change a users password with phpMyAdmin: www.youtube.com/watch?v=K8eE2LiC8FE&feature=youtu.be