Wordpress Snippets

Update WordPress Password via SQL (No phpMyAdmin)

Run this from a plugin or a file that will be executed.

global $wpdb; 
$wpdb->query( "UPDATE wp_users SET user_pass= MD5('new-password') WHERE user_login = 'known-username'" );

Refer: https://stackoverflow.com/a/23635330/8255629

Hire Us. Or just say Hi!
Need a job? Apply to get one.