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

OR

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

equired PHP version greater than equal to 5.4.0 AND found version is : 5.3.29 - Softaculous Prestashop not picking up correct php version

You may come across an issue while installing Prestashop via Softaculous regarding not picking up...

The MySQL server is currently offline. Mysql::initcache() failed: The mysql server is offline.

I was getting below error while accessing MySQL Databases from cPanel though MySQL service was...

ERROR :Tablespace for table exist. Please DISCARD the tablespace before IMPORT.

// While creating the table from cPanel >> PHPMyAdmin>> SQL, I was getting...

How to setup the root login alert notification email?

Its very important to keep a check on your servers and who logs into the server, From security...

How to enable Open SSL on WHM?

Before enabling open SSL, you can check whether it is already enabled on your server. Please fire...

Powered by WHMCompleteSolution