How to Reset a WordPress Admin Password

This article describes how to manually reset the WordPress administrator password in the database. Normally if you forget your password, you can use the WordPress password recovery feature to reset the password by e-mail. However, if this option is unavailable (for example, if e-mail on your site is not working correctly) you can reset the password in the database manually.


RESETTING THE ADMINISTRATOR PASSWORD IN THE DATABASE

To manually reset the WordPress administrator password in the database, follow these steps:

  1. Log in to cPanel.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin.
  3. In the left-hand pane of phpMyAdmin, click the WordPress database. A list of tables in the database appears.

Note: Typically, the WordPress database is username_wpXXX, where usernamerepresents your cPanel username, and XXX is a three-digit number.

 

  1. On the top menu bar, click SQL.
  2. Copy and paste the following statement into the SQL query text box. Replace new_password with the new password, and replace admin_username with the administrator's username.

    UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";

    • This SQL statement creates an MD5 hash of the password you specify. WordPress requires that passwords are stored in the database in this format. If you try to update the password field directly with the new password, you will be unable to log in to WordPress.
    • Some versions of WordPress use the table name wp_users, while other versions use a different name (for example, wpe6_users). If your WordPress version uses a table name different from the one in the above statement, use it instead.
  3. Click Go. phpMyAdmin updates the database with the new password.
  4. You should now be able to log in to WordPress as the administrator by using the new password.

 

  • WordPress, reset password, admin password
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Add MailChimp Subscribers from WordPress

You can add subscribers directly to a MailChimp mailing list from WordPress. This article...

Broken Image Links in WordPress

This articles describes how to resolve a problem that may occur when you try to add images to a...

How to Add CAPTCHA Protection to a WordPress Site

This article describes how to add CAPTCHA protection to a WordPress site using the Google CAPTCHA...

How to Add External RSS Feeds to your WordPress Site

This article demonstrates how to add an external RSS feed to a WordPress site. RSS (Rich Site...

How to Add a Custom Logo to WordPress

This article describes how to add a custom logo to a WordPress site. Adding a logo to your...

Powered by WHMCompleteSolution