Can I recover my WP-admin username and password in phpMyadmin?

Using phpMyAdmin you can get your username, but not your password. But that’s not a big deal.

When you go into phpMyAdmin and into your database, look for the ‘wp_users’ table. Remember that the prefix on it may not be ‘wp_” so it migth be a little bit different. In that table you will see the ‘user_login’ column, and that’s your username. You can’t get your passowrd this way because it’s securely hashed so that it can’t be replicated if someone managed to hack into the database. If you need to you can also change your email address here as well.

When you have your username, you can reset your password using the standard WordPress system, and then you’ll have both again.

Thanks michael.
Using your help and a suggestion from another responder I was able to fix this problem.

In phpMyAdmin it showed my username as “admin”. I was unable to reset my password with this username in the usual fashion. It kept asking for an email in order to allow reset of the password and it refused all email addresses I’ve ever used. So I went back into phpMyAdmin and put the original long numerical password back into the password field AND added an email in the blank email field. When I tried to log in to WP-admin it refused to accept my credentials as before. But this time I was able to request a reset of my password using “admin” as my username and the email address I had added in phpMyAdmin. Now all works fine again. I have no idea how this problem spontaneously occurred after weeks of being able to log in with no problem.
John