Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  phpMyAdmin  >  How To Reset WordPress Password With phpMyAdmin?
Top Scroll

How To Reset WordPress Password With phpMyAdmin?

 2 min

This article provides you steps for resetting your WordPress password through phpMyAdmin.


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

  • The list of databases is displayed, select the database of your WordPress website.

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

Your password has now been successfully reset.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.