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.
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.
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.
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!
54 comments
interesting information
Thank you –
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.
Most welcome – Keep visiting for more …:)
OH This is great information!! I didn’t know this!
Thank you very much –
great info! bookmarking this post of yours!
Thank you Very Much
I’m sure this will come in handy later. I’ve bookmarked your page so I can refer back to it.
Yes, you can reach to this anytime.
Thank you very much-
this is great info to know if you ever need to reset your password!
Thank you – Keep visiting for more.
Really interesting, extremely informative post to reset admin password.
Thank You-
Thank you for sharing! This might come in helpful
Good to hear-
Thank you
This is great information!
Thank you –
That’s very good to know!! I don’t know how many times I’ve locked myself out of my blog…
Thank you –
Thanks for sharing this info it’s going to help in a long way. Sometime I do forget so very useful.
Good to Hear ! Thank you –
These days with dealing with memory loss forgetting logins is a real problem. Tools like this would be helpful.
Thank You –
wordpress always seams uneasy for me, I often google every simple thing about it. thanks for useful post!
Thank you – keep visiting … 🙂
This is very helpful information for people who need to know how to do this. Thanks for sharing.
You are welcome – and Thank you ..: )
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!
Sure, Thank you –
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!
Thank you very much – Keep visiting.
This is pretty cool. I have never heard of this method before until now. I will make sure to bookmark this page for later.
Thank you –
Such a great and very informative post. This can be very helpful for. So many things I’ve learned about Wordpress. Thanks for sharing,
Good to hear, Thank you –
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.
Thank you for Visiting –
Great article. This is a topic I know I need to learn more about and you really helped me understand some good ways.
🙂 Thank you –
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.
🙂 yup.. I hope this helps a lot. good to hear, Thank you –
great for those with good idea of myaql, but after this everyone can try it out
yup, it can try even those who are new to Wordpress. Thank you – 🙂
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.
🙂 thank you
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.
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.
I am much satisfied by having your comment on my website. So grateful for loving the content. 🙂
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.
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!
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!
constantly i used to read smaller content that as well clear
their motive, and that is also happening with this post which I am reading at this
place.
Excellent post. I definitely love this website. Keep it up!