Home / Web Development / How To Reset Your WordPress Password Using phpMyAdmin

How To Reset Your WordPress Password Using phpMyAdmin

This articles shows how to reset or change the wordpress password using phpMyAdmin. You can directly change your wordpress password using phpMyAdmin in the database.
For change the wordpress password follows some steps . They are:

Step 1: Login to cPanel.

Step 2: Under the Databases section, click on phpMyAdmin.

Step 3: Click on the name of your WordPress database.

Step 4: Next click on the wp_users table.

Step 5:Click on Edit beside your WordPress admin user.

Step 6:In the user_pass field, paste your password by pressing Ctrl – V. From the drop-down, select MD5.
Finally click on Go.

Step 7: You should now see a success message from phpMyAdmin saying the database record was updated.

Detail Description:

  • Step 1 – Identify the Name of your Database
  • Step 2 – Locating Database and Editing the Fields

Step 1 – Identify the Name of your Database

For changing your wordpress password, first identify the name of your wordpress database. Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password.
You can easily find wp-config.php file in WordPress root directory. In wp-config.php, you will find the name of your database, username,database password etc.

Step 2 – Locating Database and Editing the Fields

In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.

cpanel_step2

Begin by logging into phpMyAdmin and clicking databases. A list of databases will appear. Click your WordPress database.

resetpass1

Select wp_genesis database and after selecting wp_user table from the database for reset password.

resetpass2

Look for the row named user_pass (usually the 3rd one) and make the following changes:

resetpass3

  • Under the Function field, set it to MD5.
  • Under the Value field, enter your new password – let’s say mikerotch.
  • Click on Save Changes.

resetpass4

Awesome, now you’ve reset the WordPress admin password.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Leave a Reply

Your email address will not be published. Required fields are marked *

Social Media Auto Publish Powered By : XYZScripts.com