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

#145 - Table './database_name/table_name' is marked as crashed and should be repair

I was getting below error while accessing one site - Error in establishing database...

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

While running one query from cPanel >> PhpMyAdmin, I was getting this error message -#1227...

How to prevent xmlrpc attack on the WordPress?

To prevent xmlrpc attack in WordPress website just add below code to the .htaccess file of the...

root @hostname emails are frozen on the cPanel server

I have configured WHM >> Edit System Mail Preferences page but emails are not getting...

Domain ****.com has outgoing email disabled.

I was getting below error message while sending emails - This message was created automatically...

Powered by WHMCompleteSolution