How to Reset a WordPress Password from phpMyAdmin

Are you trying to reset your password and not able to get in your site? Sometimes you don't have access to the email account that your user is set up with or your site is not correctly sending you the email. We've helped hundreds of users solve this issue and have created this video to help guide you on how to reset your WordPress password from phpMyAdmin.

WordPress makes it easy to reset your password on the login page but can sometimes have an issue either sending the email or you may have lost access to the email attached to your user. When this happens you would want to go through your hosting area to get to your phpMyAdmin.

This is normally under the databases section of your hosting dashboard which can be called your cPanel. Click on the link and it should open a new interface and list the databases attached to your account.

Most first time site owners should only have one database with the _users, _terms, options, and possibly tables named after plugins active on your site. Your prefix can be wp or it could be something else by your hosting's security.

You will want to click browse for the _users table to see the users on your site. Find the user you want to change the password for and click the edit link.

Replace the text in the value field to the password you want to be your new password then in the function dropdown select MD5. Once you do that click Go/Run at the bottom of the page and it will update your password on your site.

Text version of this tutorial

If you liked this video, then please Like and consider subscribing to our channel here for more WordPress videos.

Check us out on Facebook

Follow us on Twitter

Check out our website for more WordPress Tutorials
#WordPress #WordPressTutorial #WPBeginner

[salihsalu]

Saved My Website 😍😍😍👏👏👏 Thanks For this Video ❤❤❤

[kandaman]

Thanks for the refresher!
I haven't had to change my WP password until now. This really helped me a lot.

[willem]

Great tip. I'm having so much websites to cover that it could be useful

[tushargaddi]

ayee it worked! Got so frustrated when I wasn't getting a password reset email lol thanks!

[selmabelkheir]

May god give you all the blessings that you want!!!! This worked so perfectly well

[kamalrajaryal]

really amazing your problem will be solved with 3 simple steps

[keysncoffee]

This was the video that helped me! Thank you!

[hamzamoiz]

I was looking for a tutorial to change my password. I forgot about the previous one. This video helped me a lot. Thank you <3 <3

[Freecpapadvice]

You are awesome! Just what I needed. Really appreciate you making this video.

[faisalriazahmad]

Thanks a lot ... very informative I got my problem resolved.

[NikoImpressions]

Thank you for sharing this. It was really helpful.

[ahmodakramchoudhury]

Thank you... It saved my website... ❤❤❤

[TheCannibal]

thank you so much, I wasn't able to get the mail to reset my password and this help me.

[farhanferoz]

Thank you just now i watch your video and i successfully reset. thanks once again....

[maguaism]

Thanks abundantly you have made me proud n am happy for the video

[m.ahtisham]

That's working... awesome... thanks a lot for this help...

[sairamurs]

You did great job. I could reset the password. Super thank you!

[equiz]

That worked. Thanks, straight to the point!

[szilardmolnar]

Thank you very much, you saved me. :)

[kepalabergetar]

Thank you for helping people like me, keep sharing your knowledge. :)