How to reset your WordPress Password using phpMyAdmin?

How to reset your WordPress Password using phpMyAdmin?

There are several methods you can use to reset a WordPress password for a specific account. You can reset a WordPress password using FTP, or as explained in this article, you can reset WordPress password using the phpMyAdmin web interface.

Get more : What kind of password makes your Website secure ?

And it is not that hard, as you might be thinking, you just have to go through given steps and reset WordPress password within a minute and gain back access to your WordPress blog or website.

So, let’s start to hack.

Step 1 – Connect to WordPress Database with phpMyAdmin

To connect to the WordPress database with phpMyAdmin, login to your hosting provider cPanel. Scroll down to the phpMyAdmin section and click on the Databases icon which is  in the below screenshot.

Connect to WordPress Database with phpMyAdmin
Connect to WordPress Database with phpMyAdmin

Step 2 – Select the WordPress database

When inside Databases section, select the WordPress database form the list of databases. If you have multiple databases or you are not sure which is the right WordPress database, you can find the database name from the wp-config.php file. The wp-config.php file can be found in the root directory of WordPress and the WordPress database name can be retrieved from the following line:

define('DB_NAME', 'YOUR_DATABASE_NAME');

Select the WordPress database

Select the WordPress database

Step 3 – Select the WordPress Users table

After you click on the WordPress database you will see a list of tables. If you have not renamed the table prefixes, all the table names will start with the ‘wp_’ prefix.

Select the WordPress Users table

Select the WordPress Users table

Click on the wp_users table and click on the Browse tab ( in the above screenshot) to browse the content of this table, i.e. the list of WordPress users and their settings.

Get more: Create Custom page and set it as your WordPress Homepage

If you only have one WordPress user, the table will only contain one row as seen in the below screenshot.

Wordpress User table

WordPress User table

Step 4 – Reset the WordPress password

When you see screen as in above screen shot, click on edit button (the little pencil head at side). Then it opens a window just as below screen shot, where, you can notice the user password is stored as a long string of random characters (MD5 hash) in the ‘user_pass’ column as in the below screenshot. WordPress stores the password in such format for security reasons.

Reset the WordPress Password phpmyadmin

Reset the WordPress Password phpmyadmin

You can simply start typing the new password in the value section of the user_pass column. Once you specify the new password (tcs123## in the below example) select MD5 from the Function column drop down menu for the user_pass column so the password is stored using MD5 checksum and not plain text.

Change WordPress Password Security type

Change WordPress Password Security type

Click on Go button to save the new password. Congratulations. You have just reset a WordPress user password using phpMyAdmin.

Get more: Link Twitter username to your Posts automatically [Free Plugin]

This tutorial was performed in XAMPP localhost server, you can try it live from your webhost cPanel, if you find any error while resetting your WP password, then please leave a comment, I will surely look forward to that.

Advertisements

2 thoughts on “How to reset your WordPress Password using phpMyAdmin?”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s