How to Reset the WordPress Password Through phpMyAdmin

If you are a WordPress user it’s essential to know how to rest the WordPress password from phpMyAdmin because at some point of time your website is hacked and your email is changed you are no longer have any way to reset your password.

I have helped couple of people recently to reset their password therefore I made a decision to write a tutorial on this topic.

WordPress runs on MySQL database and you can access the same through phpMyAdmin even if you don’t have a cPanel. Follow the steps to reset your WordPress account password through phpMyAdmin.

Step 1 – Identify Your Database Name

In some cases there will be multiple databases available in your account or you might be running multiple installations within a same database. So it’s very important to identify the database to know where to reset the password.

To find this go to your WordPress directory and identify the the DB name in wp-config.php file.

Step 2 – Access the Database 

Once you get the name of the database, go to your cPanel or any other admin panel you are using and access the MySQL database through phpMyAdmin.

reset wordpress password

Once you’re in phpMyAdmin screen, you need to find out the correct database name at the left hand side. Search for the name you get from wp-config.php file and click on it.

You’ll see number of tables with a wp_ prefix in most cases. If you’ve changed the prefix during the installation you’ll see the tables with that prefix; eg: wp007_

Step 3 – Edit the Database Fields

Locate the table named (prefix)_users and click on it.

How to Reset the WordPress Password Through phpMyAdmin

You’ll see the list of users registered in your website. The blog admin will be at the top with a user ID 1. Now click on Edit.

You will see all the information associated with the account. In that user_pass field is where your encoded password stored.

Delete the full text in user_pass field and type the new password text you want to use. Remember that the password is case sensitive. After entering the password, choose MD5 from user_pass function field.

In the following example my password is ‘WordPress7′.

Check the password is correct and click on the ‘Go’ button at the right side bottom.

You’ll return to the earlier users page and the password is successfully changed from phpMyAdmin.

You can access your WordPress by using the new password now.

About Jose Tinto

WordPress Consultant, Professional blogger, technology enthusiast and the founder of HelloWeb. Follow me on Twitter at @thejosetinto or Add me to your Google+ circles.

Speak Your Mind

*