Log into MySQL from command line<\/p>\n\n\n\n
mysql -u root -p<\/pre>\n\n\n\nSelect the correct database<\/p>\n\n\n\n
USE wordpress_db;<\/pre>\n\n\n\nPrint current users<\/p>\n\n\n\n
SELECT * FROM wp_users;<\/pre>\n\n\n\nShould get something similar to the following<\/p>\n\n\n\n
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><\/pre>\n\n\n\nTo update the password use<\/p>\n\n\n\n
UPDATE wp_users SET user_pass = MD5('NewPass') WHERE ID=1;<\/pre>\n\n\n\nThe MD5 hashes the NewPass and adds it to the database. You can print the users again to verify the hash changed. <\/em><\/p>\n\n\n\n
You should now be able to login using the new password you configure.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Continue reading