Home How to How to Reset WordPress Admin Password using PhpMyAdmin

How to Reset WordPress Admin Password using PhpMyAdmin

by Wikky
2033 views

Sometime ─you forgot your administrator password and you don’t even remember the registered email. If you are developing the website using WordPress application that is running on localhost and forget its admin password. Under these scenarios don’t need to waste your time by trying wrong password again and again. All you need to follow below steps and get reset your wordpress admin password using PhpMyAdmin. Using the same method you can also reset any of the registered user’s password.

recover-wordpress-password-
recover-wordpress-password-

Reset WordPress Admin Password using PhpMyAdmin/Mysql

This is the only way to reset your wordpress admin password from your mysql database that resides under PhpMyAdmin.

Please note: Do not try by yourself if you are not developer and/or don’t feel comfortable while doing this. I suggest you to get help from expert.

Steps 1: Login to your CPanel dashboard.

Step 2: Click on phpmyadmin  link that is located under Database tab as shown in image below.

recover-password-phpmyadmin
recover-password-phpmyadmin

Step 3: Look for “wp_users” table and click on it to open. “wp_users” table is used to store all registered accounts for your WordPress application. “wp” is the prefix used for safety purpose and was given at the time of installation.

Your database will be located on the left side. Click on it to explore all tables. If there are more than one databases in the list, then go in to your wp-config.php file and find your database name there.


database tables – phpmyadmin – password reset – step 3

Step 4:  Now Click on EDIT button from the table records of your desired admin account. Make sure that you have clicked on correct Edit button in case of many user accounts.

User account records – phpmyadmin – password reset – step 4

Step 5: Now the EDIT Form is on the screen. Under the “columns” heading look for “user_pass”, Select MD5 from function dropdown and enter new password in value textbox. Then Click on Go button located at the end of the EDIT Form. (See image below)


EDIT Form – phpmyadmin – password reset – step 5

You have done updation of your account for your forgotten password with User interface. Now go to your wordpress login page and enter your updated credentials.


You can also reset your forgotten password using SQL Statement through PhpMyAdmin. This way of resetting password will works if you have correct “username” with you. Simply run the following from the SQL tab. Update parameters “update_password” with the value that you want to set now for your account and “your_username” values that already have with you.

UPDATE `wp_users` SET `user_pass` = MD5( ‘update_password‘ ) WHERE `wp_users`.`user_login` = “your_username“;

Hope this helps!


    You may also like

    52 comments

    royalflush99 April 1, 2019 - 3:15 pm

    interesting information

    Reply
    wikky April 10, 2019 - 4:20 am

    Thank you –

    Reply
    Arun April 10, 2019 - 4:30 pm

    Thank you for this information . I forget these things so easily. And not good with technology stuff. So it’s going to be super helpful.

    Reply
    wikky April 10, 2019 - 5:57 pm

    Most welcome – Keep visiting for more …:)

    Reply
    Ashli Ferguson April 10, 2019 - 3:49 am

    OH This is great information!! I didn’t know this!

    Reply
    wikky April 10, 2019 - 4:21 am

    Thank you very much –

    Reply
    Jessa B. | The Travel Belle April 10, 2019 - 4:31 am

    great info! bookmarking this post of yours!

    Reply
    wikky April 10, 2019 - 4:41 am

    Thank you Very Much

    Reply
    Tammie Reinhart April 10, 2019 - 5:10 am

    I’m sure this will come in handy later. I’ve bookmarked your page so I can refer back to it.

    Reply
    wikky April 10, 2019 - 5:31 am

    Yes, you can reach to this anytime.
    Thank you very much-

    Reply
    Danielle Wolter April 10, 2019 - 6:10 am

    this is great info to know if you ever need to reset your password!

    Reply
    wikky April 10, 2019 - 11:42 am

    Thank you – Keep visiting for more.

    Reply
    Ritu Sharma April 10, 2019 - 11:56 am

    Really interesting, extremely informative post to reset admin password.

    Reply
    wikky April 10, 2019 - 12:48 pm

    Thank You-

    Reply
    Lieze Neven April 10, 2019 - 1:11 pm

    Thank you for sharing! This might come in helpful

    Reply
    wikky April 10, 2019 - 3:11 pm

    Good to hear-
    Thank you

    Reply
    Maartje van Sandwijk April 10, 2019 - 2:09 pm

    This is great information!

    Reply
    wikky April 10, 2019 - 3:08 pm

    Thank you –

    Reply
    Emmeline April 10, 2019 - 5:45 pm

    That’s very good to know!! I don’t know how many times I’ve locked myself out of my blog…

    Reply
    wikky April 10, 2019 - 5:52 pm

    Thank you –

    Reply
    Lydia Smith April 10, 2019 - 5:54 pm

    Thanks for sharing this info it’s going to help in a long way. Sometime I do forget so very useful.

    Reply
    wikky April 10, 2019 - 6:00 pm

    Good to Hear ! Thank you –

    Reply
    Blair April 10, 2019 - 7:19 pm

    These days with dealing with memory loss forgetting logins is a real problem. Tools like this would be helpful.

    Reply
    wikky April 10, 2019 - 7:28 pm

    Thank You –

    Reply
    Lyosha April 10, 2019 - 9:01 pm

    wordpress always seams uneasy for me, I often google every simple thing about it. thanks for useful post!

    Reply
    wikky April 11, 2019 - 4:52 pm

    Thank you – keep visiting … 🙂

    Reply
    brie April 10, 2019 - 9:30 pm

    This is very helpful information for people who need to know how to do this. Thanks for sharing.

    Reply
    wikky April 11, 2019 - 4:52 pm

    You are welcome – and Thank you ..: )

    Reply
    Jasmine M April 11, 2019 - 12:20 am

    This is a great way to make sure that you can log into your WordPress admin account. I’ll have to bookmark this for later!

    Reply
    wikky April 11, 2019 - 7:00 pm

    Sure, Thank you –

    Reply
    azirtak April 11, 2019 - 1:37 am

    Oh wow! So much i didn’t know about having to reset that main password! I bet it’s important to change it often! I’m definitely saving this post in case of an emergency! Thanks!

    Reply
    wikky April 11, 2019 - 7:01 pm

    Thank you very much – Keep visiting.

    Reply
    Sue-Tanya Mchorgh April 11, 2019 - 5:45 am

    This is pretty cool. I have never heard of this method before until now. I will make sure to bookmark this page for later.

    Reply
    wikky April 11, 2019 - 7:02 pm

    Thank you –

    Reply
    Alexandra Cook April 11, 2019 - 12:08 pm

    Such a great and very informative post. This can be very helpful for. So many things I’ve learned about WordPress. Thanks for sharing,

    Reply
    wikky April 11, 2019 - 7:03 pm

    Good to hear, Thank you –

    Reply
    Clare Minall April 11, 2019 - 12:09 pm

    I found WordPress so complicated to use. I am new to blogging so I need to learn more things about using it. Thank you for this useful guide.

    Reply
    wikky April 11, 2019 - 7:07 pm

    Thank you for Visiting –

    Reply
    Preet April 11, 2019 - 12:09 pm

    Great article. This is a topic I know I need to learn more about and you really helped me understand some good ways.

    Reply
    wikky April 11, 2019 - 7:15 pm

    🙂 Thank you –

    Reply
    Samar April 11, 2019 - 3:47 pm

    I was actually stuck in the same point, I had to contact web host to get it resolved.
    Now i can do it from my end.

    Reply
    wikky April 11, 2019 - 7:04 pm

    🙂 yup.. I hope this helps a lot. good to hear, Thank you –

    Reply
    Ogbugbu Ejiroghene April 12, 2019 - 1:37 am

    great for those with good idea of myaql, but after this everyone can try it out

    Reply
    wikky April 12, 2019 - 4:56 am

    yup, it can try even those who are new to WordPress. Thank you – 🙂

    Reply
    Nina Cochingco April 15, 2019 - 7:39 am

    Such a helpful blog post. I had save my password in my phone and in my notebook, so I’m pretty sure I won’t forget it. But in case,this will be so useful. Thanks for sharing.

    Reply
    wikky April 16, 2019 - 4:53 pm

    🙂 thank you

    Reply
    apply For medicare April 30, 2020 - 2:41 am

    What’s up, I wish for to subscribe forr this blog to take most recent updates, so where can i do it please help out.

    Reply
    Бизнес Онлайн April 4, 2021 - 10:23 pm

    Hi i am kavin, its my first occasion to commenting anyplace,
    when i read this paragraph i thought i could also
    make comment due to this sensible paragraph.

    Reply
    Wikky April 10, 2021 - 5:47 am

    I am much satisfied by having your comment on my website. So grateful for loving the content. 🙂

    Reply
    http://billsillimanphotography.com/__media__/js/netsoltrademark.php?d=bukovets.comwinter May 16, 2021 - 8:20 am

    Hi there to all, how is the whole thing, I think every one is getting more from this site,
    and your views are nice in favor of new viewers.

    Reply
    bukovets May 16, 2021 - 3:16 pm

    Woah! I’m really loving the template/theme of this blog.
    It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between user friendliness and
    visual appearance. I must say you’ve done a excellent job with this.
    In addition, the blog loads super quick for me on Firefox.
    Exceptional Blog!

    Reply
    bukovets May 16, 2021 - 3:17 pm

    Woah! I’m really loving the template/theme of this blog.
    It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance”
    between user friendliness and visual appearance.
    I must say you’ve done a excellent job with this.
    In addition, the blog loads super quick for me on Firefox.

    Exceptional Blog!

    Reply

    Leave a Comment

    This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More