How to reset the password for WordPress through phpMyAdmin

Table of Contents

One of the reasons why a company like LastPass got so popular – it is impossible for a man to remember all the passwords and logins. And what happens when you need to reset the password for accessing the WordPress site that you forget and cannot remember, even under the threat of your project’s final “dip”? At such moments, you can get assistance from this post. We will discuss how to “reset” the forgotten password in it.

 

The procedure of “zeroing” and the recovery password in WordPress should be divided into two parts:

 

  • Restoring password using phpMyAdmin
  • Password recovery with MySQL (if phpMyAdmin is not installed on your server).
  •  

Restoring the WordPress admin password using phpMyAdmin

 

To start, run Import phpMyAdmin. If you are using WAMP or its variants, then just click on the icon in the taskbar and select Import phpMyAdmin:

 

phpmyadmin-from-wamp

 

If you use shared hosting and cPanel, have to log in to cPanel and select phpMyAdmin under the Databases:

 

phpmyadmin-from-cpanel

 

Once in Import phpMyAdmin, select the database you used to install WordPress. In this practical guide, assume that the database is called wp_genesis:

 

select-database-from-phpmyadmin-2

 

We look at the table item called wp_users and select it. In most scenarios,  the “hidden” password is there. But those who carefully adjust the WordPress security may add their prefix to the name given by default. Prefix wp_ added to the table and point the users. If you have used the prefix type ptbktwp_, then your table and the item are appropriate prefixes: ptbktwp_users.

 

2 The following table will help you understand how this works:

 

Using the default prefix wp_:

 

select-wp_users-table-with-custom-prefix

 

select-wp_users-table

 

Use your prefix ptbktwp_

 

edit-password-under-wp_users-in-phpmyadmin

 

For simplicity, assume that wp_ is the prefix for the users. After loading the table, we look for the same user name chosen when installing WordPress. The name proposed by default and is most often used – is admin. Click on the yellow icon in the shape of a pencil (Edit) next to the admin:

 

Look at the line user_pass and make the following changes to it:

 

reset-wordpress-password-in-phpmyadmin

 

In the Function, specify the properties of the MD5.

 

In the field Value, enter the new password – for example, mikerotch.

 

Save the work done:

 

save-changes

 

Now we have successfully changed our password to a new one.

 

settings-changed-640x126

 

You can try to go to the site with the new console password.

 

We hope you can change your forgotten password by following these steps.

 

Fully Managed WordPress Hosting

Nestify’s AWS powered dedicated CPU servers keep your sites fast, secure, and always up to date.

Want faster WordPress?

WordPress Speed Optimization

Try our AWS powered WordPress hosting for free and see the difference for yourself.

No Credit Card Required.

Whitelabel Web Hosting Portal Demo

Launching WordPress on AWS takes just one minute with Nestify.

Launching WooCommerce on AWS takes just one minute with Nestify.