Sunday, 20 November 2016

How to Change your WordPress Password using PHPMyAdmin?

Image Credits go to Pixabay
You may face a situation when you don't know the password for WordPress Dashboard or might have forgotten it. But if you have access to the database via phpmyadmin, you can reset password from there.

5 Tips to Create Strong & Easy to Remember Password

So let's begin :)

1) Simply open phpmyadmin.

2) On left side, there will be shown the names of databases.

3) You need to know your database name. It is where your WordPress password is stored. So you can reset it.

Finding out your Database Name

  1. Go to the main directory of your site and open file called wp-config.php
  2. After opening that file, press CTRL+F and type "DB_Name" without quotes  there. Then press Enter.
  3. You will see your database name just beside 'DB_Name'. For Example, my database name is parc.

4) Alright, now lets come back after finding your database name. Select your database in phpmyadmin.

5) After selecting your database, you will see something like that.

6) Now you will be seeing table names on the left side. Click on the table called wp_users. You will then see user names and their further details on the right side. Click on Edit, depending on which account's password you want to change. Right now, there are 3 people who are registered on my site. That's why it is showing me 3 user accounts.

7) After you clicked on Edit, you will see some kind of a form on next page. In the 3rd row, you will find user_pass field. In the same row, click on the drop down menu in Function column and select MD5. Just like shown in the below picture.

8) Now the last step is to simply enter your new password as shown in the below picture and click on Go button.

Congrats!!!, you changed your password.

Now you can go to the WordPress login page and login using your new password.

I have tried to keep this tutorial as simple as possible for you guys. Don't forget to like it or share it with your friends :)


  1. Nice. Thanks for the trick. Gonna try it on my blog

    1. Yeah sure, feel free to message me if you face any issue. Thanks :)

  2. Your ability to recall random factoids at just the right time is impressive you can inspire many peoples by writing articles you have done very amazingly hats off to you, thanks for sharing this to us from. I'm very glad to see this article It is very informative useful and inspiring for others from. content-writing


  3. Wonderful article. Really helpful for me for my website

  4. Thanks for sharing this blog. It was very informative.
    Read the blogs on mobile marketing and give us you feedback at Sandeep Banger's blog..

  5. Thanks for sharing this informative blog. Read Sandeep Banger blogs
    to know tricks and trends of mobile marketing

  6. The mobile advertising market is poised for exponential growth over the next several years. There are several obvious reasons for this growth,thanks for sharing.

  7. Coolbargain Online Shopping Store

    Women's Clothing · Men's Clothing · Jewelry & Watches · Sports & Entertainment · Toys & Hobbies · Shoes · Consumer Electronics · Beauty & Health · Phones & Accessories · Baby & Kids · Bags · Automobiles & Motorcycles · Computer & Office · Home & Garden · Security & Protection · Furniture · Home Improvement · Best Online Fashion Store

    Shopping, Women's Clothing, Men's Clothing, Jewelry & Watches, Sports & Entertainment, Toys & Hobbies, Shoes, Consumer Electronics, Beauty & Healte

  8. Shweta Mahajan lives in Delhi. She is very sizzling and gorgeous , when you connect about sensual Delhi Escorts then men have their particular favorite. So to whole the call for of each man is dissimilar. Former his request now not finishes in their actual life Indepentdent Delhi escortsand female friend in this condition they pursue different female to surface their want.
    Delhi Escorts
    Indepentdent Delhi escorts
    Call Girls in Delhi
    Delhi Escorts Services
    Escorts Service In Delhi
    Delhi Feamle Escorts
    Delhi Call Girls
    Delhi Escorts
    Gurgaon Escorts
    Nodia Escorts
    Ghaziabad Escorts
    Faridabad Escorts
    Greater Noida Escorts

  9. Do you know that WordPress is not just for blogging? In fact, besides being favored by bloggers, WordPress is also a powerful content management system (CMS). Now, for every 100 websites, more than 58 of them are powered by WordPress. Its clients range from Reuters to the New York Times and Forbes to e-commerce sites like eBay. You might wonder if this popular choice will fit your needs. Is WordPress the most effective and efficient option? Click links here to find out >>> .