26 Jun
2024
If you have forgotten your WordPress administrator password, you can easily reset it as long as you have access to your website’s web hosting control panel.
Check your email for the login credentials provided for your cPanel or Plesk hosting management environment.
Alternatively, contact the provider that manages your website hosting and request your access credentials.
Once you are logged into the hosting control panel, follow these steps:
1. Access phpMyAdmin
Go to the phpMyAdmin tool.
This is usually located under the Databases section of your hosting control panel.
2. Select your WordPress database
Inside phpMyAdmin, locate and click your WordPress database from the list of databases in the left sidebar.
If you are not sure which database your WordPress website uses, you can find this information inside the wp-config.php file located in your WordPress installation directory.
3. Open the users table
Find the table named wp_users.
Note: the wp_ prefix may be different if a custom table prefix was chosen during installation.
4. Edit the administrator user
Locate the row that contains your administrator username and click the Edit link next to it.
5. Change the password
In the user_pass field, enter your new password.
However, it must be encrypted using the MD5 algorithm, because WordPress stores passwords in hashed format.
In the Function dropdown menu next to the user_pass field, select MD5.
Then type your new password in plain text inside the Value field.
6. Save the changes
Scroll down and click the Go / Execute button to save your changes.
Your new password will be hashed and stored securely in the database.
By following these steps, you should be able to successfully reset your WordPress administrator password through phpMyAdmin.
Once completed, try logging back into your WordPress admin panel using your username and the new password at:
https://www.mysite.com/wp-admin