How to Reset Your WordPress Password with a Database

Step 1: Log in to Ashuli Hosting Dashboard 

Step 2: Navigate to the hosting account

Once you’re logged in to the Ashuli Hosting Dashboard, click on ’service’ and select the hosting account you wish to install WordPress on.

Prerequisites:

• Access to your WordPress database (phpMyAdmin is a popular tool used for this)
• Knowledge of basic SQL queries

Steps:

1. Log in to phpMyAdmin.

[Screenshot of phpMyAdmin login page]

2. Select your WordPress database.

In the left-hand pane, you will see a list of all the databases on your hosting account. Select the database that your WordPress site is using.

[Screenshot of phpMyAdmin database selection page]

3. Locate the wp_users table.

This is the table that stores all of the user information for your WordPress site.

[Screenshot of phpMyAdmin wp_users table]

4. Click the “Edit” button next to the user whose password you want to reset.

This will open a form where you can edit the user’s information.

[Screenshot of phpMyAdmin edit user form]

5. Delete the contents of the user_pass field and enter your new password.

[Screenshot of phpMyAdmin edit user form with new password entered]

6. From the “Function” drop-down menu, select “MD5”.

This will encrypt your password before it is stored in the database.

[Screenshot of phpMyAdmin edit user form with MD5 function selected]

7. Click the “Go” button at the bottom of the form to save your changes.

[Screenshot of phpMyAdmin edit user form with Go button clicked]

That’s it! You have now successfully reset your WordPress password using the database. You can now log in to your WordPress site using your new password.

Tips:

• Be careful when editing the database, as a mistake could break your WordPress site.
• If you are not comfortable editing the database yourself, you can contact your hosting provider for assistance.
• It is always a good idea to back up your database before making any changes.

How to Reset Your WordPress Password with phpMyAdmin Database on Ashuli Hosting

Prerequisites:

• Access to your Ashuli Hosting cPanel
• Knowledge of basic SQL queries

Steps:

1. Log in to your Ashuli Hosting cPanel.

[Screenshot of Ashuli Hosting cPanel login page]

2. Scroll down to the Databases section and click on the “phpMyAdmin” icon.

[Screenshot of Ashuli Hosting cPanel Databases section]

3. Select your WordPress database from the list of databases on the left-hand pane.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin database selection page]

4. Click on the “wp_users” table.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin wp_users table selection page]

5. Click the “Edit” button next to the user whose password you want to reset.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin wp_users table edit button]

6. Delete the contents of the user_pass field and enter your new password.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin wp_users table edit form with new password entered]

7. From the “Function” drop-down menu, select “MD5”.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin wp_users table edit form with MD5 function selected]

8. Click the “Go” button at the bottom of the form to save your changes.

[Screenshot of Ashuli Hosting cPanel phpMyAdmin wp_users table edit form with Go button clicked]

That’s it! You have now successfully reset your WordPress password using phpMyAdmin on Ashuli Hosting. You can now log in to your WordPress site using your new password.

Tips:

• Be careful when editing the database, as a mistake could break your WordPress site.
• If you are not comfortable editing the database yourself, you can contact Ashuli Hosting support for assistance.
• It is always a good idea to back up your database before making any changes.