Forgotten my Wordpress login details

I set up a simple Wordpress site on a Virtual Machine, but I've forgotten any sign-in details I set up.

How do I fix this? I've tried "forgotten password" but I don't seem to have set the user with my email address.

I have full control over the VM.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineDon't talk to me.Commented:
Check the database and look in the wp-users table.  The first (usually only) user in that table is the administrative user you created when you installed WordPress. You should be able to get the username and email from there and do a password reset.
Loganathan NatarajanLAMP DeveloperCommented:
Additionally look at the details here too,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
purplesoupProgrammerAuthor Commented:
Thanks for this - sorry I was off on holiday and didn't respond sooner.

I can look at the user table and in fact had remembered the email address I had used, but I get a message saying mail has not been installed (or set up - something similar) so I can't get the email link.

I had a look at the resetting your password link where it explains getting an MD5 hash of a new password and updating the user table. I will have to wait for tomorrow to do this now as my VM was running incredibly slowly because it was installing updates, and so I have had to quit and let the updates run.

However hopefully soon I will have this resolved - thanks for your help. I'll update tomorrow.
purplesoupProgrammerAuthor Commented:
Sorry for the delay - I am now up and running.

I thought up a new password.

I created an MD5 hash for it here:

I ran MySQL Workbench and updated the wp_users table, updating the user_pass column with the new MD5 hash.

I then logged in with my new password and was able to get in.

Thanks for all your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.