Sunday, April 20, 2025

Reset WordPress Admin Password via MySQL Command Line


mysql -umyUserName -paVeryStrongPassword

show databases;
 
use myWordpressDB;

SELECT ID, user_login, user_pass FROM wp_users;

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

SELECT ID, user_login, user_pass FROM wp_users;

How to display dynamically all records matching the selected value

 Assuming: Data range: A3:J1061 Dropdown selection: D2 Criteria column: J4:J1061 Headers are in row 3. Enter this formula in the cell where ...