How to Reset a Forgotten Password in WordPress from phpMyAdmin

Reset a Forgotten Password in WordPress

Well hello and welcome again, this is Mosam again…!! Recently my site-mate Charmie wrote tutorial on Android with Phonegap, did you just check that out? No? Then you may refer these links:

1) How to create an Android app with Phonegap using Eclipse?

2) How to create a Phonegap build for an Android app: Part 2

So friends today I’m posting for how you can reset your WordPress password from phpMyAdmin.  This technique is not particularly a technique for a reset, but it does allow you to totally reset your password. It just requires a few additional actions, and a little basic knowledge of MySQL. This guide in particular will be using the MySQL from our hosting cPanel.

Step 1: Login into your cPanel

Step 2: Search to the symbol for phpMyAdmin and just click.



Step 3: Simply select the database table that connect  with your WordPress website. In fact, if you do not know what database is connect with your website  don’t worry, open the wp-config.php to find out.

Step 4:  Search for wp_users and just click to open this database table.


Step 5: Search for the your username and click to edit button for edit your password


Step 6:  As you can see in this image, there is a position to put a security password. When you first see, it, it will look like a lot of alphanumeric character are in that area. eliminate those characters and put your security password you want. The different characters are there because WordPress only identifies security passwords by means of MD5 security. You will want to put your own security password in the writing area and then choose MD5 in the drop down menu.
Once you have done this 3 steps , simply select the button that says GO and your security password has been totally reset.


So guys and girls, its as simple as that and you are also just a few steps away from trying this tutorial on your own. In case you feel to harass me you can freely ask me your doubts. 🙂

Mosam Gor

A tech-blogger. WordPress caprice. Simplistic. A geek. SocialMediaMarketer. Music and Movie freak. Affiliate marketer. Short tempered. Crazy about Gadgets. An Strong experienced in web designing through HTML and CSS.For me free time means playing with WordPress and maintaining my other blogs and websites. I am interested in playing “tabla, djembe & piano”. Add me on Google+

You may also like...

12 Responses

  1. This is something unusual kind of problem but is very helpful if ever faced in such a trouble. Your images are clear enough to explain and the post is easy to follow. Thanks for writing about it.

  2. I seriously like such tricks other than hacking tricks. This is obviously a nice trick worth noticing. 🙂

  3. Mubashir says:

    Its nice information for WordPress users. So they don’t need to contact their hosting company every time when they required password reset or else.
    Thanks for sharing

  4. Wao,nice article on how to reset password from php myadmin,but i dont know why i do have phobia of editing anything in my cpanel

  5. This is indeed a great resource, i remembered being in such a fix someday when i was a newbie blogger and almost deleted my blog because i couldn’t login to my dashboard. I hope this helps other people who may find themselves in such situation.

  6. hello mosam and charmie. thank you for sharing this tip since i also suffer sometimes in short term memory lost. at least i know what to do when reseting passwords. i usually write clues of my passwords on my journal to remind myself which password should i use.

  7. Pawan says:

    Awesome! A long time back(about an year ago), I forgot the password of one of my old unused blog. I wasn’t aware of the any such method at that time as I was newbie in blogging. I wish I knew something like this before. I had to delete the installation and re-install it again. Bookmarked this page. 😉

  8. Sriram says:

    Nice trick to know Mosam. I had never faced this problem on WordPress, will refer this post if I faced such issues. Thanks for the post 😀

  9. Raj kumar says:

    Hi Mosam, many times this happens that we forget password and this post will be very helpful. Thanks……….

  10. fazal mayar says:

    Thanks for this what a great tutorial. I always forget my password and Im tired of it so this will help

  11. ebimablog says:

    Waoooo,never knew this is the product my host has been using for me anytime i forger or something happen to my password,thanks for sharing

  12. Karan says:

    Thanks a lot author! This is the trick I was looking for, since my website was stuck and I had no clue how to proceed. Once again, thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *