Following the PHPMyAdmin instructions of this article fails to reset my password properly.

I go into WP_Users, find my admin account, click edit, enter my password, change the dropdown to MD5, click save, but this password does not work when I try to login to WP-Admin with this username.


5 Answers 5


Here is a picture explaning how to do it
be carful and backup the database befoure any changes are done

first here is a link to md5 encoder (youll need it): MD5 Encoder

howto change password in phpMyadmin

Hope this helps ;)
Cheers, Sagive.


Try using a web-based MD5 generator, and then paste the generated MD5 value directly into phpMyAdmin without using phpMyAdmin's MD5 function. When using the generator, choose a simple password, like "temp123" to avoid any potential issues with complexity. Then once you can login to WordPress, use the Admin Panel to change ithe password back to something strong.

If that doesn't work, try the lost password feature or the FTP method. The lost password feature is probably the easiest. If you need to, you can use phpMyAdmin to update the e-mail address associated with the e-mail account.


Set your admin ID and run this statement in your PhpMyAdmin

UPDATE wp_users SET user_pass = MD5('12345') WHERE ID=1;
  • this one helped me! since there was no MD5 in the PhpMyAdmin interface!!!
    – Guy Cohen
    May 16, 2017 at 5:27

How about changing the admin e-mail in the field specified above by Sagive and then retrieving it via /wp-login.php

  • "Password reset is not allowed for this user". This user is the network admin.
    – Steve
    Apr 2, 2012 at 7:20

When in doubt, hack away. If you are a little confused with the MD5 in the phpmyadmin you can try saving the email to a file.

1) If your site is live, this will require using FTP. I recommend using Filezilla as it makes FTP very simple. You will need to create an FTP user in your C-Panel if you haven't already.

2) Find the file "wp-includes\pluggable.php" and drag it to a folder. Open the file. I recommend opening the file in a text editor like notepad plus or sublime.

3) Hit CTRL + F to find (mac is CMD + F). Type in "wp_mail". Scroll down about a hundred lines until you find...

$phpmailer->Body = $message;

This should be around line 370.

4) Right below that line insert this code...

$f = fopen("email.txt", "w");
fwrite($f, $message);

5) Once the file is saved drag and drop it into the FTP window to upload it to the server.

6) Load the login page and click "Lost Password." Once you click to send an email the email will be saved to "email.txt". From there you should be able to reset everything.

7) After you have recovered your password change "wp-includes\pluggable.php" back and delete email.txt immediately! This hack will leave your site vulnerable. Recover your password and change it back, you'll be okay. Forget to change it back I am not responsible.

  • You should never modify core on a live site Aug 3, 2016 at 7:05
  • I tried this, and it didn't work for me. That said, if you want to do something like this, consider creating a plugin, since all functions in wp-includes/pluggable.php are designed to be overwritten... Dec 7, 2017 at 16:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.