Click WordPress - Your one stop solution for all your WordPress Requirements
Menu
How to reset your WordPress Website Password hosted on Local Host
- Raajul Sharma
- Publish Date - August 17, 2023
- Update Date - August 17, 2023
- Time to Read 3:44 pm
Facebook
Pinterest
LinkedIn
Reddit
WhatsApp
Email
Print
image credits @ freepik
Table of Contents
Resetting your Localhost WordPress Password was never so easy!
Introduction
When we work on a wordpress installation inside local host, we sometimes need to reset the password for the wordpress installation. Since local host is running on your system and is simulating a web server there are limited options to reset the password for your wordpress installation on your local host.
There are three ways to reset the password for your wordpress installation, installed on your local host. They are follows
1. Through the PHP admin(preferred method) – Covered in this tutorial
2. Through WordPress admin dashboard directly. – Please click to learn How to change the WordPress Password using WP – Admin
Why do we need to change or reset the password on Local Host
In most cases, you need to reset a WordPress installation’s password on your local host, because you may have forgotten it and then there can be other miscellaneous reasons as well.
How to change the password of your WordPress Installation on Local Host
To change the password of your WordPress installation installed on your local host, follow the steps given below.
1. Switch on xampp or any other local host running app that you may be using. In this tutorial behave used xampp.
2. After xampp has started switch on the Apache server and the My SQL services as shown in the screenshot below.
3. Once the two services have started, head over to your web browser and type local host.
4. If the local host page loads properly you should see something called the PHP my admin in the menu section of that page.
5. Click PHP my admin and enter the database section of your local host.
6. Inside the PHP my admin locate the wordpress installation for which you are trying to reset the password.
7. Once you have located the correct user for which you trying to reset the password click on it to load the different tables on the right hand side of the panel.
8. On the left hand side panel you will see a number of tables with different names locate the table name users in it. Please no that sometimes there are multiple tables and their can be a second page to that table and if you are not being able to find the correct table then you might have to click the second or the third page inside the left hand side panel see the image below to understand.
9. Once you have located the correct table called users click on it to load it on the right hand side of the panel.
10. Choose the username for which you wish to reset the password and click edit on the left hand side of that username
11. Once you click edit on the username for which you wish to reset the password. You will see a number of small boxes being loaded on the right hand side of the panel. As shown below in the screenshot there will be a small box which will be mentioned by something like user_pass. In the box front of it, is the current password for that username, but it is in the encrypted form.
If you try to use this as the password this will not work as this is the encrypted form of the current password.
12. Click on the encrypted password and select all of it and delete it.
13. Once you have deleted the current password Enter the new password.
14. In the drop down on the left hand side of the entry box click on it and choose md5.
Md5 is the Encryption Algorithm which is used by wordpress to encrypt all the passwords inside its database. If you do not encrypt the password it will not work.
15. Once you have chosen md5 in the drop down scroll down below as for the screenshot and click go.
16. The the database query will now fire and will change the password and encrypt it as well.
This marks the completion of the process of changing the password of your WordPress installation on your Local Host using PHP my admin.
Connect with us
related posts
Click WordPress is a single window support for all your WordPress related requirements. You can find exhaustive content on the following WordPress DIYs, WordPress Troubleshooting, Woocommerce, WordPress Plugins, WordPress Themes
- clickwordpress111@gmail.com
Useful Links
- Home
- About Us
- Blog Categories
- Advertise with us
- Terms & Condition
- Privacy Policy
- Contact Us
- User Sitemap
Blog Categories
- WordPress DIYs
- Pure WordPress
- WordPress News
- WordPress Plugins
- WordPress Themes