How to reset your WordPress password using phpMyAdmin. Print

  • Wordpress, Troubleshooting, Password
  • 0

phpMyAdmin

As an alternative, you can reset the password for a user via the WordPress database. To do that, open the phpMyAdmin tool in your cPanel and select the WordPress database from the left side of the page.

dbtables.png

Then click the SQL tab and type the following query in the text field:

UPDATE `wp_users` SET `user_pass` = MD5('new_password') WHERE `wp_users`.`user_login` = "username";

In the above query replace new_password with the new password for the user and username with the full username of the user.

Once you've entered the query hit the Go button.


Was this answer helpful?

« Back