How to Reset a WordPress Password from phpMyAdmin

Forgot you password to login into your wp-admin dashboard ? No problem ! As long as you can login into your Cpanel or into the server where you have WordPress running there is a way out ! You can do this using phpMyAdmin, MySql client or any MySql client. You need to know the name of the user and have a password in mind. After you login into your MySql database (phpMyAdmin or any other method from above) you need to update the table called wp_users referencing your user. Example:

  • make sure you are logged into the right database(in case you have more wp databases)
use my_wp_database;
UPDATE wp_users SET user_pass= MD5('new_password') WHERE user_login='user'; 
flush privileges;
  • this should fix it.
I hope this was helpful