If you’ve forgotten your WordPress dashboard login, and can’t use the Reset Password tool because you can’t remember which email address or username is correct, there’s an easy way to fix this using the phpMyAdmin tool in your cpanel.
1. Login to your website cPanel
If you’ve forgotten how to do this, please click here
2. Click on the phpMyAdmin icon
You’ll find it in the “Databases” section of your cpanel
phpMyAdmin will open in a new tab/window
3. Click on the correct database in the menu on the left
Expand the menu tree if necessary, by clicking on the [+] sign
4. Click on the correct database
In this case, it’s texoco_wpx. Your database will have a different name. If you have more than one database listed, and you’re unsure which one is being used by your WordPress install, you will find this information in your wp-config.php file.
5. Select the users table by clicking on it
All your database tables will be listed in the frame to the right. Look for the table with the _users extension. Yours will be named differently, depending on the database prefix your install is using. In this example, it is wpx_users. Click on it.
6. Click on the Edit link next to the username
7. Remove the encrypted password
Select and remove the encrypted password in the textarea.
8. Type in a new password, selecting MD5
Enter the new password for this user, and change the dropdown to MD5
9. Click on the Go button to save the new password.
You can now login to your WordPress dashboard with the user_login and the new password.