How to reset WordPress administrator password?

You can follow below steps to reset the WordPress administrator password -

1. Login to cPanel
2. Go to phpMyAdmin
3. Click on your site's database.
4. Click on table wp_users.
5. Click on Edit option, in-front of username.
6. Update the value of password from 'user_pass' field. Make sure to select the 'Function' filed as MD5.
7. Go


You can fire below SQL query to update the WordPress administrator password under -

1. cPanel >> phpMyAdmin >> SQL -

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

3. Click on Go.

That's it! 
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

The page isn’t working, site is currently unable to handle this request. HTTP ERROR 500

While accessing WordPress site's sub-links and back-end (WordPress admin dashboard ) I was...

How to renew the cPanel license on your server?

Quickest way to renew cPanel license - First, you may check if the server has valid license for...

Access Denied. Unable to establish a PHP session.

I was getting below error while accessing phpMyAdmin - Access Denied Unable to establish a PHP...

587 sender verify fail for <email address>: No Such User Here

I was getting the error while sending email as -587 sender verify fail for <email address>:...

Install PHP-SSH2 extension in cPanel

PHP SSH2 extension to be loaded into the cPanel server as this module is not available inside...

Powered by WHMCompleteSolution