phpMyAdmin Life Saver: Change/Reset Password and Admin Name
24 10 2007
There are moments in life that you might say "OOH SH$T! What was the password", I lost my WordPress admin name, I don’t remember it, I didn’t get the email with my password, etc. Well nothing to despair, the solution takes less than two minutes. To proceed you need to log in into your website control panel that most likely is provided by your web host, and most like you have phpMyAdmin too. In fact we need phpMyAdmin to put our hands into WordPress database and do modifications in there, but remember it is not a playground, a mistake and you can say bye bye to your blog. Just don’t wonder what the "drop" link might do, simply follow these few steps and you should bet alright. Just to be on the safe side, ALWAYS backup your database, if you have no clue how to do that just read my other tutorial.
Warning, messing around with you WP database could cause loss of data and other problems
Please follow the tutorial, if you have any problem don’t hesitate to leave a comment. I wont be held responsible for you mistakes
A short description of the video: I assumed you got into phpMyAdmin , we need to look for the table that contains the users info and edit the user name and its password, as you can see there are other values we can edit as well such as email address ect. I wont cover every value displayed and what they refer to, we just focus on the user name and password however some of these values as you see are self explanatory.
So we decided to change admin to something else and since we are there we change the password too.
Talking about passwords, WordPress requires MD5 algorithm encryption for stored passwords, you will notice that I select the function MD5 from a dropdown list, that will process the password we enter by using client-side MD5 encryption, so don’t panic when you see as user password something like this 0f63b2c0873e8cvd29ba465328721a18n9.
After the modifications have been saved you should be able to log in back into your WordPress, if you have any problem either contact me or make a stop at wordpress.org support forum
Thanks for watching and good blogging.
[...] Video: http://www.francescolanza.com/2007/10/24/password-admin-reset/ Related Articles:Samuel B on "Password on local install reset"netstyledesigns on [...]
[...] Password Admin Reset (video) [...]
Recycling will be the salvation of the world.
Reply
jeez thanks for these steps, it’s really scary for me to get into phpMyAdmin but I have to
Reply
There are so many times that I’ve forgotten my WordPress admin password that now I write them down somewhere so that I won’t have to go into all the hassles later on!! The phpMyAdmin which allows you to change or reset our password and admin name will be a big help for people like me in such situations!! With the tutorial given here, it’s just a question of going through it and doing as directed which will be easy for amateurs like me!! Lucky that I happened to see this blog!!
Reply
I try few weeks to change a browser at the vs 2010 and now i try secondly to work according to instruction and i don’t success can you guide me? secondly, that you say firefox, you mean to url adress? thank you for your help
Reply
The video demonstration is no longer showing. Please put it back up if you can. Or you can try putting it on youtube and embedding the youtube video here.
Reply
Rodney Daut is rite! The video is not showing anymore. Please update it with the correct link
Reply
Good stuff here! you should never mess with your WP database.
Reply
The amount of times I have found myself in this situation! Thanks your a wordpress legend!
Reply
You have given very good information about resetting the admin name and password. After reading this, we will not face any kind of difficulty while changing password. Thanks a lot.
Reply
The video is not showing anymore. Please update it with the correct link.. Very Nice…
Reply
That was a really great information, Thanks for sharing this info, Please keep posting a great article like this.
Reply
Video doesn´t work
Reply
I just bookmarked this old but so useful post. I confess phpmyadmin scares me a bit too when I need to make some changes.
Reply
Good work! I always like to leave comments whenever I see something unusual or impressive. I think we must appreciate those who do something especial. Keep it up, thanks
David Mayer
Reply
keep on going? many usefull info here? thanks a lot)
Reply
The video is not showing anymore.
Reply
I already knows that trick. Thanks for sharing it.
Reply
keep on going, thanks,nice blog!
Reply
yes we made it.
Reply
Thank you for the tip!
Reply
so nice good job
wallpapers
Reply
Thank you for the tip
Reply
Good work! I always like to leave comments whenever I see something unusual or impressive. I think we must appreciate those who do something especial. Keep it up, thanks
Reply
Thank you for this great article. I think it’s very useful for everybody. I have been visiting your site for a while and I suggest everybody to read other articles in this site.
Reply
It is nice to find a blog that written by a human, rather than auto posting garbage. I am very enjoyed for this blog. Keep up the excellent work!
Reply
It is nice to find a blog that written by a human, rather than auto posting garbage. I am very enjoyed for this blog.
Reply
Thank you for the tip!
Reply
It is nice to find a blog that written by a human, rather than auto posting garbage. I am very enjoyed for this blog.
Reply
so nice good job!!
Reply
Il mondo antico conosce il terrore diurno, che si cristallizza nell’ora del mezzogiorno e che trova proprio nell’ombra dell’uomo e delle cose un’importante e significativa testimonianza. L’identificazione fra l’ombra e l’anima e il nesso fra vita e morte si caricano
Reply
asdasdssssssssssssssssssssssssaaaaaassaaaaaaaaaaaaaaaa
Reply
Yeah, it happened a lot with me. Thanks for helping me out.
Reply
Well nothing to despair, the solution takes less than two minutes. To proceed you need to log in into your website control panel that most likely is provided by your web host, and most like you have phpMyAdmin too.
Reply
My opinion over this topic is perhaps not so impressive like the reader’s point of view. But i am pretty glad to add new information in my memory after reading such phenomenal addition over your blog. Happy sharing please
Reply
I’m not going to say what everyone else has already said, but I do want to comment on your knowledge of the topic. You are truly well-informed. I can’t believe how much of this I just wasn’t aware of. Thank you for bringing more information to this topic for me. I’m truly grateful and really impressed.
Reply
Good article with a lots of informations!
Reply
You can watch the video by clicking on the blue banner below the article. Very good share!
Reply
Good stuff here! you should never mess with your WP database.
Reply
Very Interesting. Thanks for sharing With us.
Reply
Pretty interesting, keep up the good work. Thanks.
Reply
It’s actually a great and useful piece of info. I am satisfied that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing
Reply
You clearly know what you are doing. It’s good to see this information in your article.
Reply
I already knows that trick. Thanks for sharing it.
Reply
Very interesting information for me, thanks…
Reply
I have been planning to buy one so that I can take my family on fishing trips on the weekends. I hope that I do not get looted in the process!
Reply
How would we change the password of admin without giving old password and other login details?
Reply
Your style is really unique in comparison to other people I have read stuff from. Thank you for posting when you’ve got the opportunity, Guess I will just book mark this blog.
Reply
I faced many times that issue, but as usual call to my web host company and solved the problem.
Reply
How can we change the password without going to Email?
Reply
I was very pleased to find this website. I wanted to thanks for your time for this wonderful read! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post.
Reply
Thanks your a wordpress legend!
Reply
Is that possible to change the password through other Email.
Reply
Nice post. I learn something new and challenging on websites I stumbleupon every day. It’s always interesting to read through content from other authors and use a little something from other sites.
Reply
We get a handle on such information quite a bit. Having been trying to get the following particular content a long time. Appreciation and also undertaking.
Reply
Great post on password admin reset!
Reply
Its sounds really great, definitely will try when my site is ready for launch.
Reply
Hi
It is nice to find a blog that written by a human, rather than auto posting garbage. I am very enjoyed for this blog.
best great!
pflege-aus-polen24h.com
Reply
This is a good tip especially to those fresh to the blogosphere.
Brief but very precise information… Thank you for sharing this one.
A must read article!
Reply
Thank you, I was going crazy looking for information on this topic, it’s good to know that there are people who selflessly help
Reply
I would like to take the chance of thanking you for your professional advice I have usually enjoyed going to your site. I’m looking forward to the actual commencement of my university research and the overall preparing would never have been complete without coming over to this site. If I might be of any help to others, I would be ready to help as a result of what I have gained from here.
Reply
I can not thank you sufficiently for the articles on your web-site. I know you place a lot of time and energy into these and hope you know how considerably I enjoy it. I hope I’ll do the identical thing man or woman at some time.
Reply
I’m not sure where you’re getting your info, but good
topic. I needs to spend some time learning much more or
understanding more. Thanks for excellent information
I was looking for this information for my mission.
Reply
Hey! I could have sworn I’ve been to this website before but after browsing through some of the post I realized it’s new to me.
Anyways, I’m definitely delighted I found it and I’ll be book-marking and checking back often!
Reply
You are so cool! I don’t believe I’ve truly read through anything like this before. So nice to find another person with genuine thoughts on this issue. Seriously.. many thanks for starting this up. This website is something that is required on the internet, someone with a bit of originality!
Reply