How To Reset WordPress Password With phpMyAdmin?

• 22 October 2021
• in: MySQL

This tutorial helps you to understand the steps for resetting your WordPress password through phpMyAdmin.

Requirements:

• You will need the name of your WordPress database.
• You will need your cPanel login credentials (username and password).

To Identify the Database for your WordPress Website:

• Login to your cPanel account.
• Click File Manager on the cPanel dashboard.

• Browse to the location of your domain folder and view the wp-config.php file.

• You’ll find the database file as shown below:

Accessing phpMyAdmin:

• Navigate to ‘database group of icons’ and click on ‘phpMyAdmin’.

Enter A New Password:

Here are the steps for changing the password in the database.

• • In the table list, click on the users table. Note that the table prefix might vary for every website. Please refer to the below screenshot to get the idea.

• Click on the ‘Edit’ option present next to the user you want to set the password for.

• Enter the password in the Value box of the user_pass field.
• In the Function box present next to the password option, select MD5.
• Click on ‘Go’.