WordPress CMS admin password reset

How to reset a lost 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;

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

SELECT * FROM wp_users;

Reset WordPress admin password through FTP

If you don’t have direct access to your MySQL database, and you wish 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.

Read this too:   How to fix Joomla HTTP 500 errors after updates

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 this post helped you solve a problem? Or dit you find it interesting? Support Sysadmins of the North with a direct donation via Paypal of by bank wire transfer IBAN: NL31 ABNA 0432217258 (Jan Reilink). Just $ 5,- or € 5,- is more than enough, thanks!



Leave a Reply

Your email address will not be published. Required fields are marked *