If you’ve forgotten your WordPress admin password, don’t worry. You can easily reset it by accessing your website’s database through phpMyAdmin. Here is How to Change a WordPress Password Using phpMyAdmin:
Step 1:
Access phpMyAdmin The first step is to log in to your web hosting account and find phpMyAdmin. Once you find it, click on it to open the interface. You will be prompted to enter your username and password to access the database.
Step 2:
Select the database After logging in, you will see a list of databases. Select the one that corresponds to your WordPress installation. If you’re not sure which database to select, you can find it in your website’s wp-config.php file. Look for the following line of code:
define(‘DB_NAME’, ‘database_name’);
The ‘database_name’ is the name of the database you need to select.
Step 3:
Locate the wp_users table Once you’ve selected the correct database, you will see a list of tables. Look for the table that begins with ‘wp_’ and ends with ‘_users’. This table contains all the user information, including usernames and passwords.
Step 4:
Edit the user password Click on the wp_users table to open it, and you will see a list of users. Find the user whose password you want to reset and click on the ‘Edit’ button next to their username.
In the ‘user_pass’ field, you will see a long string of random characters. This is the encrypted password for the user. To reset the password, delete the current value in the ‘user_pass’ field and replace it with a new password.
Note: Make sure you select ‘MD5’ from the dropdown menu to encrypt the new password before saving it.
Step 5:
Save the changes After entering the new password and selecting ‘MD5’ from the dropdown menu, click the ‘Go’ button to save the changes.
Congratulations! You have successfully changed your WordPress password via phpMyAdmin.
In conclusion, changing your WordPress password via phpMyAdmin is a straightforward process. If you forget your password, don’t panic. Just follow the steps outlined above, and you’ll have access to your WordPress installation in no time
