Forgotten wp-admin Password and Username – WordPress

Retrieve WordPress User Name

Go back to PhpMyAdmin, go to the ‘SQL’ tab, and paste this:

SELECT * FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE meta_value LIKE '%administrator%'

You should get a list of all the users with the ‘administrator’ role. One of those should be your account. You ought to recognize the email address or something. Then use the password reset function at /wp-login.php to straighten things out. Be sure to check that the email address in the database is an address you still use. If not, change it so that you get the reset email.

Resetting_Your_Password