WordPress CMS admin password reset

Photo of author
Written By Jan Reilink

Windows Server system administrator & enthusiast.

How to reset your WordPress password? If you’ve lost or forgotten your WordPress admin password, you can easily reset the password. Either use the following MySQL statement to reset your WordPress admin password, or change it through functions.php.

Reset WordPress password through phpMyAdmin/MySQL

Use either phpMyAdmin or mysql’s command-line.

The following MySQL statement resets your WordPress password to default. Don’t forget to set a new password after logging on to your WordPress Dashboard through your Profile settings:

UPDATE `wp_users` SET `user_pass` = md5( "default" ) WHERE `id` = 1;
Code language: SQL (Structured Query Language) (sql)

Change wp_ to your WordPress MySQL table prefix. You can look up the WordPress user ID with the query:

SELECT * FROM wp_users;
Code language: SQL (Structured Query Language) (sql)

Reset WordPress admin password through FTP

If you don’t have direct access to your MySQL database, and you want to reset your WordPress admin password through FTP, follow the following steps:

  1. log on to your website using FTP, and download your theme’s functions.php file
  2. edit the functions.php file, and add on the second line (right below <?php): wp_set_password( 'default', 1 );. This will set the password to default for the user with ID “1”.
  3. upload the file back to your website, to its original location
  4. log on to your WordPress website using this new password, change your password through your Profile settings, and remove the code from functions.php. Otherwise your password will be reset each time you try to login.

Or you can do the downloading, editing and uploading of functions.php in one go, by editing a file through FTP. The article is in Dutch, but you can Google Translate the article or look at the screenshots.

Note: both methods set a new password using the old and insecure MD5 algorithm. This is not secure! Nowadays, the WordPress password hasher implements the Portable PHP password hashing framework, which is exactly the reason why you have to change the password as soon as possible after logging on.

Through the automatic emailer

If you know your username or the email account in your profile, you can use the “lost password” feature of WordPress. If all else fails, use the emergency password reset script.

More password resets: Umbraco

Lost your Umbraco password?

Did you like: WordPress CMS admin password reset

Then please, take a second to support Sysadmins of the North and donate!

Your generosity helps pay for the ongoing costs associated with running this website like coffee, hosting services, library mirrors, domain renewals, time for article research, and coffee, just to name a few.

Hi! Join the discussion, leave a reply!