WebHostingPeople Blog

How Can We Help?

How to Reset WordPress Password?

You are here:

In this tutorial, we will explore different ways to reset your WordPress password.

Have you ever misplaced your WordPress admin password? Do you know how to reset the password if you don’t have access to the WordPress dashboard? There is an option called “Forgot Password” on the WordPress admin login screen. You can simply reset it by clicking on the link and following the instructions. But what if someone intruded into your WordPress installation, reset your password, and changed the email address so that the password reset email goes to another address? What can you do in this situation? Have you heard of an option that allows you to reset the password from the database? In this article, we’re going to learn how to reset the WordPress admin password from the database.

As you may be aware, WordPress installed websites are database-driven sites. You need at least one database to complete the WordPress installation on your website. We’re going to see how we can use this feature to reset the WordPress admin password and regain control. However, this is not recommended for beginner-level WordPress admins. Please contact us so that we can assist you by restoring the website from an older backup or providing another solution. If you’re familiar with cPanel and can manage PHPMyAdmin or have enough technical knowledge to work with Linux, MySQL commands, you can proceed with the following procedures to reset the WordPress password.

 

Reset WordPress password with PHPMyAdmin

There are many ways to access the database. PHPMyAdmin is a tool that can help you access your website’s databases. PHPMyAdmin can be opened from the cPanel Interface. Our Standard Web Hosting provides you with cPanel as the control panel, and you can open PHPMyAdmin from cPanel. With PHPMyAdmin, you can do this task without requiring any technical knowledge.

Password-Reset

 

We’re going to update the wp-users table with the necessary values to reset the WordPress Admin password.

 

Steps to reset the password in PHPMyAdmin

1) Log in to your cPanel interface.

2) Click on the option ‘PHPMyAdmin’ from the ‘Databases’ category.

Password-Reset

 

3) Enter the WordPress database. The WordPress database is usually prefixed with “wp”. However, this is not always true. A user can change this during the WordPress installation configuration. The databases will be listed in the left panel, and you can select the database from there.

4) Enter the wp_users table.

Once you have entered the WordPress database, you can access the tables inside the database. The tables will be listed under the database name as subtrees. Usually, the table prefix is wp_. You need to locate the wp_users table and enter it.

5) Edit with your WordPress username.

6) In the user_pass field, set the function to MD5 and enter the new password in the Value field.

7) Click on the button “Go”

You have completed the steps to reset the WordPress admin password.

 

Reset WordPress password with Command Line Interface.

This is an alternate method to do the same thing, but with the command line interface. To do this, you need to have SSH access to the server. You can get the details of how to access the server via SSH with Putty here: https://webhostingpeople.in/tips/kb/using-putty-to-ssh-to-server/.

1) Enter MySQL with the following command.

$ mysql -u username -p

Password:

Now you need to enter the password to connect to the MySQL server.

2) Now, please enter the following command.

$ UPDATE `wp_users` SET `user_pass`= MD5(‘yourpassword’) WHERE `user_login`=’yourusername’;

Please remember to replace “yourusername” and “yourpassword” with the correct username and new password, respectively.

Now you can login to the WordPress admin dashboard with the username and new password.

 

If you need any further assistance, please contact our support department.

 

 

Post Your Comment