are you using the xampp server to temporarily host your site and for testing? what if you forgot your xampp localhost’s WordPress admin password?
so through this article, I will show how we can reset our xampp localhost’s password using the xampp MySQL database with just a few clicks.
changing WordPress password in MySQL.
to change your localhost WordPress password make sure you have installed the xampp server on your computer/laptop. or you have access to your MySQL database. check if you using any other localhost provider.
so here we are using xampp as a localhost server and I’m going to show you how to change the wp-admin password in the xampp server.
first of all, open your xampp server on your computer or laptop.
Now start/activate Apache and MySQL Module from xampp’s dashboard.
when you successfully started your apache and MySQL. then just click the MySQL admin button from your xampp server. or copy this link and paste it to your browser.
http://localhost/phpmyadmin
now if all is going good then you will see the MySQL database is successfully open in the browser or you will see an error. (if you see an error comment below we can help you)
your MySQL database is opened now select the site database where you want to edit.
in my case, I want to change my password for Dwarka so I just selected Dwarka.
when you select your database then you will redirect to your database page where you see multiple rows and columns in the table.
from there just find the “wp_users” and click that link. then you will see all users that you created to handle or manage your WordPress database.
find the account that you want to reset the password basically if not created multiple accounts then it will show just one account so confirm and click the edit button.
Now you will see all details of the user just confirm and make changes if you want to change anything else otherwise just find the “user_pass” from the column and you will see your old password in an encrypted format.
just remove that password and enter there the new password that you want to use next time.
wait that’s not the end after changing your password go to the function column and select function as an “MD5” and then scroll down and click the Go button
Now Go to your WordPress admin login page and enter your new details and click the login button. 99% of you will log in successfully if still have any doubts please write us in the comment.
what is xampp?
Xampp is the local host server. where you can host your site temporarily. xampp provides you a MySQL database as well as Apache, PHP, and Perl, by using this you can able to text and modify without purchasing any costly servers.
also, you can install WordPress on the xampp server which is really good for all programmers. who want to test their site for WordPress.
xampp is one of the popular if you want to use another localhost platform to test and modify your site then just check this all out which is an alternative for xampp.
A list of the most commonly XAMPP alternatives is below –
- WampServer
- EASYPHP
- AMPPS
- Desktop Server
- ERBuilder
- MAMP
- Laragon
- Apache HTTP Server
- Zend Framework
- UwAmp Server
that’s it in this article we learned what is xampp? and How To change the WordPress password in localhost?
Hope you liked this and we solved your query if you have any questions or suggestions please write us in a comment box. we’ll try our best to solve your query SAP 🙂