How to Change Your WordPress Backend Password via phpMyAdmin - DreamIT Host

Our Blog

How to Change Your WordPress Backend Password via phpMyAdmin

Jun 09, 2021

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.

Screenshot: cPanel Login Screen


2. Under the Files section, click File Manager.

Screenshot: Files Section of the Control Panel


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

Screenshot: 'public_html' Folder

Screenshot: Contents of 'public_html' Folder Highlighting the 'wp-config.php' File


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

Screenshot: Right-Click of the 'wf-config.php' File


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’.

Screenshot: Contents of the 'wf-config.php' File

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.

Screenshot: Databases Section of the Control Panel


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).

Screenshot: List of Databases on the Left-Hand Side Panel


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’.

Screenshot: List of Tables Highlighting 'wpa9_users'


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’.

Screenshot: Entries Within 'wpa9_user'


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

Screenshot: Entries Within 'wpa9_user' Highlighting the 'Edit' Button


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

Screenshot: Form with a List of Entries Highlighting 'user_pass'


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.

Screenshot: ‘user_pass’ Section with MD5 Selected from the Drop-Down List and a Value Column to Enter Your New WordPress Backend Password


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

Screenshot: Completed Form with New WordPress Backend Password Details


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