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 change your WordPress url via the Database

How to change your WordPress installation’s site URL in the event you no longer have access to...

How to Move WordPress From Local Server to Live Site

Developing a WordPress site locally can help speed up the development process. In the past, we...

How to change your Password in WordPress

The purpose of this tutorial is to teach you how to change your password in WordPress. You...

WordPress .htaccess

# BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule...

HOW TO CHANGE A MULTISITE PRIMARY DOMAIN

If you want to change the primary domain of your WordPress multisite installation, there are 5...


Our official partners