Change WordPress User Password in DataBase


Change WordPress User Password in DataBase

WordPress LogoMySQL Logo

The passwords for all the WordPress users are all stored in the wp_users table.
All the passwords are MD5 hashed.

UPDATE `wp_users` SET `user_pass`= MD5('yournewpassword') WHERE `user_login`='yourusername';
  • https://wordpress.org/
  • https://wordpress.com/
  • https://www.mysql.com
  • https://www.mysql.com/products/workbench