Reset WordPress admin password in MySQL

Log into MySQL from command line

mysql -u root -p

Select the correct database

USE wordpress_db;

Print current users

SELECT * FROM wp_users;

Should get something similar to the following

mysql> SELECT * FROM wp_users
-> ;
+----+------------+------------------------------------+---------------+---------------------------+----------+---------------------+------------------------------------+-------------+--------------+
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
+----+------------+------------------------------------+---------------+---------------------------+----------+---------------------+------------------------------------+-------------+--------------+
| 1 | admin | 5f4dcc3b5aa765d61d8327deb882cf99 | admin | bob@incredigeek.com | | 2018-08-09 10:10:42 | | 0 | admin |
| 2 | bob | 210805fb52a13251f4bedc7e725e575a | bob | bob@incredigeek.com | | 2019-11-01 11:31:23 | | 0 | bob smith |
+----+------------+------------------------------------+---------------+---------------------------+----------+---------------------+------------------------------------+-------------+--------------+
3 rows in set (0.00 sec)
mysql>

To update the password use

UPDATE wp_users SET user_pass = MD5('NewPass') WHERE ID=1;

The MD5 hashes the NewPass and adds it to the database. You can print the users again to verify the hash changed.

You should now be able to login using the new password you configure.

How to Reset a Windows Password

There are multiple ways to reset windows passwords.  This one replaces the sticky key program with a command prompt from which you can change the password.

To reset the forgotten windows password, follow these steps:

  1. Boot from a Windows setup DVD.  Any setup DVD should work.  Access the command prompt.
  2. Find the drive letter of the partition where Windows is installed.  In Vista, Windows 8 and XP, it is usually C:, I have read that in Windows 7, it is D: I am not sure which one it is.  In most cases because the first partition contains Startup Repair.  To find the drive letter, type C: (or D:, respectively) and search for the Windows folder.
  3. Type the following command (replace “c:” with the correct drive letter if Windows is not located on C:):
    copy c:\windows\system32\sethc.exe c:\
    This creates a copy of sethc.exe to restore later.
  4. Type this command to replace sethc.exe with cmd.exe: copy /y c:\windows\system32\cmd.exe c:\windows\system32\sethc.exe
  5. Reboot your computer and start the Windows installation where you forgot the administrator password.
  6. After you see the logon screen, press the SHIFT key five times.
  7. You should see a command prompt where you can enter the following command to reset the Windows password:net user your_user_name new_password

    If you don’t know your user name, just type net user to list the available user names.

  8. You can now log on with the new password.

 

I recommend that you replace sethc.exe with the copy you stored in the root folder of your system drive in step 3.  For this, you have to boot up again with Windows setup DVD because you can’t replace system files while the Windows installation is online.  Then you have to enter this command:

copy /y c:\sethc.exe c:\windows\system32\sethc.exe

You are now finished.