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.

phpMyAdmin

phpMyAdmin

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.

S2

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

S3

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.

S4

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. 🙂




There are 12 comments

Add yours
  1. Suresh Khanal

    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. Mubashir

    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

  3. Nwosu Desmond

    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.

  4. marilyn cada

    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.

  5. Pawan

    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. 😉

  6. Karan

    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!


Post a new comment