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. Tableau2018 Our sessions offer something for everybody in an assortment of learning styles. To find specifics, or peruse our determination for titles of intrigue, utilize the channels on the left to limit your query items.
    Tableau2018 We're committed to planning a gathering that is the best understanding for you—reveal to us which sessions sound energizing by giving them a "Like" (tap on the thumbs up symbol). We'll utilize your information to settle on choices about arrangement and rehashes of sessions. Substance will be refreshed and included frequently, so inquire regularly.

  3. I recommend my colleagues and team members to have a look at your blog to know how exactly website building should be done. Great Article!
    white label website builder

    best iptv links 2018-2019 kodi & android supported
    watch free TV online ,all channels autoundated
    Worldwide free iptv links ,iptv m3u available 24/24 hours.Download the best free iptv links,the best free iptv urls,the best free iptv m3u.

    free worldwide iptv,iptv m3u playlist download 2018,iptv free server,iptv playlist uk download,free iptv links,free iptv uk,iptv m3u8 playlist download,iptv m3u download.

  5. Install Norton

  6. Thank you for sharing this post. I have some useful information to share regarding Mobile App Development Company.