How to reset WordPress Admin Password from the PhpMyAdmin

Here’s a detailed guide on How to Reset a WordPress Password from phpMyAdmin:


How to Reset WordPress Password from phpMyAdmin

If you’ve forgotten your WordPress admin password and are unable to reset it via the WordPress login page, you can manually reset it through phpMyAdmin by directly updating the password in the WordPress database. Follow these steps to reset your WordPress password.


Step 1: Log in to cPanel

  1. Open your web browser and navigate to your cPanel login page (e.g., https://yourdomain.com/cpanel).
  2. Enter your cPanel username and password, then click Log in.

Step 2: Access phpMyAdmin

  1. In the Databases section of the cPanel dashboard, locate and click on phpMyAdmin.
  2. This will open the phpMyAdmin interface in a new tab.

Step 3: Select Your WordPress Database

  1. In phpMyAdmin, you will see a list of databases on the left sidebar.
  2. Click on the database associated with your WordPress site. If you are unsure which one it is, you can check the database name in the wp-config.php file located in the root directory of your WordPress installation via File Manager or FTP.

Step 4: Open the wp_users Table

  1. Once you’ve selected the correct database, you will see a list of tables.
  2. Locate the table named wp_users (the prefix may be different if you’ve changed it during installation, e.g., xyz_users).
  3. Click on the wp_users table to view its contents.

Step 5: Locate Your Username

  1. In the wp_users table, you will see a list of users registered on your WordPress site.
  2. Find the row corresponding to the user whose password you want to reset (usually the admin account).
  3. Click the Edit link next to that user’s row to modify the user’s details.

Step 6: Change the Password

  1. In the user_pass field, you will see the current password, which is encrypted.
  2. Delete the current password and replace it with your new password.
  3. In the Function dropdown next to the user_pass field, select MD5. This will encrypt your new password using the MD5 hash function.
    • Note: WordPress versions 4.3 and later no longer use MD5, but this step is necessary in phpMyAdmin as the system will automatically rehash the password upon login.

Step 7: Save the Changes

  1. Scroll down and click the Go button at the bottom of the page to save your changes.
  2. Your password has now been updated in the database.

Step 8: Log in to WordPress

  1. Go back to the WordPress login page (https://yourdomain.com/wp-admin).
  2. Enter your username and the new password you just set in phpMyAdmin.
  3. You should now be able to log in successfully.

Conclusion

You have successfully reset your WordPress password using phpMyAdmin. It’s always a good idea to keep your login details secure and ensure that your email recovery options are updated to prevent needing this method in the future.


 

  • PhpMyAdmin, WordPress Admin, Forgot WordPress Admin Password, reset WordPress password, cPanel, Database, WordPress Tutorial, WordPress support, WordPress Admin Password reset
  • 0 Пользователи нашли это полезным
Помог ли вам данный ответ?

Связанные статьи

How to access webmail

To access the webmail use the following link: https://yourdomain/webmail Replace "yourdomain"...

How to access cPanel

The cPanel can be accessed via the following links: https://yourdomain/cpanel or...

How to increase Memory Limit & Maximum Upload size via php.ini

PHP Servers come with some default value for PHP configuration. To increase the memory limit or...

How to increase WordPress memory limit

WordPress memory limit is set to 32M by default. This is sometime not enough for a heavy...

How to create an email forwarder

How to add forwarder:1. Login to cPanel2. Go to “Forwarders” link3. Click on “Add Forwarder”4....

Powered by WHMCompleteSolution