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! 

Was this answer helpful?

 Print this Article

Also Read

#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...

MySQL server is currently offline. Error: Too many connections at /usr/local/cpanel/Cpanel/ line 173.

phpMyAdmin and MySQL Databases in cPanel were displaying me the below error -...

Response: 421 Home directory not available - aborting Error: Could not connect to server

While connecting to hosting service using FTP client, I was getting below error message...

ERROR: There was an error connecting to the server, Please verify the settings

While updating the WordPress plugin using FTP client I was getting the error as -'ERROR: There...

A DNS entry for 'domain_name' already exists. You must remove this DNS entry from all servers in the DNS cluster to proceed.

While adding addon domain under cPanel, I was getting error as below - A DNS entry for...

Powered by WHMCompleteSolution