How to reset Wordpress Password

login to cPanel and select phpMyAdmin found under Databases.

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password1.png

Once you’re inside phpMyAdmin, select the database that you’re using for your WordPress installation. In our tutorial, let us assume the database to be genesis_wp.

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password2.png

Look for a table entry called wp_users and select it. In most scenarios this should be the case. However, if you’re a security enthusiast, then you might have used a different prefix during the WordPress installation. The default prefix is wp_ hence the table entry wp_users. However, if your prefix was say ptbktwp_ then your user table entry would be ptbktwp_users.

The following two tables will help you understand:

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password3.png

Using the default prefix i.e. ‘_wp’

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password4.png

Using a custom prefix: ‘ptbktwp_’

For simplicity, let us consider the default prefix – wp_users. Once the table is loaded, look for the username you had chosen while installing WordPress. In this tutorial I’m assuming it’s the default username – admin. Click on the little yellow pencil icon located next to the admin entry – that’s the edit icon.

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password5.png

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

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password6.png

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

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password7.png

Now you have successfully changed your WordPress password to mikerotch.

http://kenyawebexperts.com/images/How%20to%20reset%20Wordpress%20Password8.png

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

Was this answer helpful?

 Print this Article

Also Read

How to Edit Your Profile in WordPress

This tutorial will teach you how to edit your profile in WordPress. You should be logged in, and...

How to Write a Comment in WordPress

This tutorial will teach you how to write a comment in WordPress. Log in to your WordPress...

How to Manage Pages in WordPress

The purpose of this tutorial is to teach you how to manage pages in WordPress. You will need to...

WordPress is giving error: "Missing a temporary folder" while uploading image/media ?

WordPress is giving error on image upload : "image.jpg" has failed to upload due to an error...

How to Manage Categories in WordPress

This tutorial will help you learn how to manage your categories in the WordPress program. You...


Our official partners