jasonsyourhuckleberry
9/9/2018 - 8:55 PM

WordPress password reset via phpMyAdmin

  • Run the query below where “new_password” is the new password and “admin_username” is the account you’re resetting the password on.
  • This statement creates an MD5 hash of the new password which is required by WP.
  • Updating pwd field directly won’t work.
wp-pwd-reset
content_copyfile_download
UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";