Skip links

How to Change Your WordPress Backend Password via phpMyAdmin

If you have forgotten your login for your WordPress backend, you can reset your WordPress backend password via phpMyAdmin.

 

Follow these steps to to change your WordPress backend password via phpMyAdmin:

 

First, you will need to find which database your website is utilising. To do this, you will need to access your wp-config file within your File Manager.

 

1. Log in to your cPanel account. For instructions on how to log in to cPanel, please click here.

How to Change Your WordPress Backend Password via phpMyAdmin

 

2. Under the Files section, click File Manager.

How to Change Your WordPress Backend Password via phpMyAdmin

 

3. Go to the location where your wp-config file is (most commonly stored in public_html with your other website files).

How to Change Your WordPress Backend Password via phpMyAdmin

How to Change Your WordPress Backend Password via phpMyAdmin

 

4. Once you have located your wp-config file, right-click the file, then click View.

How to Change Your WordPress Backend Password via phpMyAdmin

 

5. This will display the contents of the wp-config file. Look for the code that says: define( ‘DB_NAME’, ‘NameOfDatabase’ );

The database name will be noted where ‘NameOfDatabase’ is listed in the above code.In this example, the database name is ‘tofumomo_wp194’.

How to Change Your WordPress Backend Password via phpMyAdmin

 

Now that you have the name of the database, you will need to access phpMyAdmin in your cPanel.

 

6. Under the Databases section, click phpMyAdmin.

How to Change Your WordPress Backend Password via phpMyAdmin

 

7. On the left-hand side panel, select the database that was listed in your wp-config file. (In this case, the database is ‘tofumomo_wp194’, as per the previous screenshots).

How to Change Your WordPress Backend Password via phpMyAdmin

 

8. Once you select the database, it will provide you with a list of tables. You need to locate the table that includes the list of users who can access your WordPress backend.

This table may have different names depending on how the website was built. In most cases, it will contain the word ‘users’ in the name. In this scenario the table name you want to select is ‘wpa9_users’.

How to Change Your WordPress Backend Password via phpMyAdmin

 

9. This will open up a list of entries within the table (‘wpa9_users’). In this example, there is only one user.

You want to look for your WordPress username under the column ‘user_login’. The username in this example is ‘6gycj’.

How to Change Your WordPress Backend Password via phpMyAdmin

 

10. Now that you have located your username, click on Edit.

How to Change Your WordPress Backend Password via phpMyAdmin

 

11. You will see a list of entries, you will need to make changes to the row where it says ‘user_pass’.

How to Change Your WordPress Backend Password via phpMyAdmin

 

12. Select the drop down box under the Function column and choose the option MD5. In the Value column, remove any existing text and enter in your new password.

How to Change Your WordPress Backend Password via phpMyAdmin

 

13. Once your new password has been entered, click Go. This will save your new WordPress backend password.

How to Change Your WordPress Backend Password via phpMyAdmin

 

Congratulations! You can now log in to your WordPress backend with your new password 🙂