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.
- 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.
/** The name of the database for WordPress */
/** MySQL database username */
/** MySQL database password */
/** MySQL hostname */
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.
Begin by logging into phpMyAdmin and clicking databases. A list of databases will appear. Click your WordPress database.
Select wp_genesis database and after selecting wp_user table from the database for reset password.
Look for the row named user_pass (usually the 3rd one) and make the following changes:
- Under the Function field, set it to MD5.
- Under the Value field, enter your new password – let’s say mikerotch.
- Click on Save Changes.
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.