Recover WordPress Username and Password in Localhost

If you read this post to the end, you will understand the easy and fastest way to recover your WordPress username and password on the localhost server.

Offline WordPress helps learners or even professionals to design websites without registering a domain name or a hosting plan. I have been using Localhost WordPress for some time now, which is very flexible like the Online version.

But is very frustrating when you forget your WordPress login username or password. You will not be able to access the dashboard where you can edit or update your website.

The good news is that resetting your username or password is very easy and fast.

Watch on Youtube

How to Recover WordPress Username or Password

Follow the steps below to recover WordPress Username and Password in the Localhost Xampp server.

Open Xampp then start Apache server and MySQL: Apache is the local server while MySQL is related to Database. So the two have to be active before you can proceed.

xampp apache and mysql

Open your browser and type ‘localhost’ in the URL section and press ‘enter’: This opens up the localhost dashboard.

Click on ‘phpMyAdmin’:

phpmyadmin database

Then Select your database name: From the list of databases on the left panel, select the database associated with the WordPress website you are trying to recover its password.

choosing your database

After opening your database, scroll down and click on ‘wp-users’

select wp users then see username and password

Then locate your username and password. Note that, because your password is encrypted, it will not display in plain text. You will only see some mixed characters there as shown in the image below.

see your wordpress username and password

Click on ‘Edit’

click edit then reset wordpress username and password

Then under username and password, in the ‘function’ column, select ‘MD5’ : This is the option that encrypts the password. If you don’t select it, anyone who has access to your database can see your password.

change function to md5 then reset wordpress username and password

Then go ahead and change the username and password

reset wordpress username and password

Scroll down and click on ‘Go’

recover wordpress username and password

That’s all. Congratulations, you have successfully changed or recovered your username and password in the localhost xampp server.

You can take a full Website Design Course by clicking here.

You may also like…

Share with a friend:

2 thoughts on “Recover WordPress Username and Password in Localhost”

  1. Good post. I learn something totally new and challenging on sites I StumbleUpon every day. It will always be helpful to read content from other writers and practice a little something from other websites.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top