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.

change or reset wordpress admin name and password
You need to upgrade your Flash Player

Actions

Informations

190 responses to “phpMyAdmin Life Saver: Change/Reset Password and Admin Name”

8 05 2011
esmi on "admin name has suddenly been changed! Should I be concerned?" | Upgrade Wordpress Now (20:00:58) :

[...] Video: http://www.francescolanza.com/2007/10/24/password-admin-reset/ Related Articles:Samuel B on "Password on local install reset"netstyledesigns on [...]

1 07 2011
Resetting Your WordPress Admin Password | Way-2-Design-Media-Sources (14:00:07) :

[...] Password Admin Reset (video) [...]

16 08 2011
Baymak (21:53:05) :

Recycling will be the salvation of the world.

Reply

13 09 2011
botwa (13:45:09) :

jeez thanks for these steps, it’s really scary for me to get into phpMyAdmin but I have to

Reply

4 10 2011
mutual mobile (06:10:08) :

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

21 10 2011
essays term papers (15:38:30) :

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

25 04 2012
Rodney Daut (17:39:07) :

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

28 05 2012
moviefollow (19:26:00) :

Rodney Daut is rite! The video is not showing anymore. Please update it with the correct link

Reply

28 05 2012
california direct lenders (19:28:57) :

Good stuff here! you should never mess with your WP database.

Reply

22 06 2012
Blinds (07:28:18) :

The amount of times I have found myself in this situation! Thanks your a wordpress legend!

Reply

25 06 2012
Carports Brisbane (11:13:39) :

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

27 06 2012
Dirsur (15:41:19) :

The video is not showing anymore. Please update it with the correct link.. Very Nice…

Reply

2 07 2012
http://googlepacmancheats.com/ (06:13:31) :

That was a really great information, Thanks for sharing this info, Please keep posting a great article like this.

Reply

16 07 2012
Eva - Tarta de pañales (17:19:16) :

Video doesn´t work

Reply

28 07 2012
New iPhone 5 online (12:18:30) :

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

28 07 2012
solglasögon (18:49:08) :

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

29 07 2012
Magic (16:22:19) :

keep on going? many usefull info here? thanks a lot)

Reply

31 07 2012
Journeaux pdf (12:22:41) :

The video is not showing anymore.

Reply

2 08 2012
Electronic Cigarettes (11:12:41) :

I already knows that trick. Thanks for sharing it.

Reply

9 08 2012
Pills aviability (17:21:08) :

keep on going, thanks,nice blog!

Reply

11 08 2012
Saon islam (03:47:57) :

yes we made it.

Reply

16 08 2012
Bente Haugstad (11:44:51) :

Thank you for the tip! :)

Reply

16 08 2012
Wallpapers (12:36:21) :

so nice good job
wallpapers

Reply

7 09 2012
Headline news (21:37:59) :

Thank you for the tip

Reply

8 09 2012
dunya tv (10:19:27) :

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

23 09 2012
Rose Marie (23:44:52) :

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

7 10 2012
gift for kids (07:26:00) :

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

7 10 2012
Gift For Kids (07:27:21) :

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

9 10 2012
die-geschenke (16:40:39) :

Thank you for the tip!

Reply

9 10 2012
besth2ofilter (16:43:22) :

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

9 10 2012
odissia (16:47:24) :

so nice good job!!

Reply

10 10 2012
Directorio Web Gratuito (03:51:36) :

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

30 10 2012
dlhanbingp8 (02:24:24) :

asdasdssssssssssssssssssssssssaaaaaassaaaaaaaaaaaaaaaa

Reply

1 11 2012
Water Meter Installation (15:51:26) :

Yeah, it happened a lot with me. Thanks for helping me out.

Reply

7 11 2012
sailing schools (07:33:40) :

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

14 11 2012
http://www.papersconsulting.com/ (10:48:50) :

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

14 11 2012
professional editors (10:58:25) :

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

14 01 2013
Karl (10:50:57) :

Good article with a lots of informations!

Reply

18 01 2013
Italian Pop (23:54:11) :

You can watch the video by clicking on the blue banner below the article. Very good share!

Reply

30 01 2013
how ip address (18:27:21) :

Good stuff here! you should never mess with your WP database.

Reply

5 02 2013
Relaxation (12:03:20) :

Very Interesting. Thanks for sharing With us.

Reply

16 02 2013
used cars in louisville ky (10:03:43) :

Pretty interesting, keep up the good work. Thanks.

Reply

25 02 2013
Roatan Excursions (15:07:13) :

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

26 02 2013
london escorts (00:53:09) :

You clearly know what you are doing. It’s good to see this information in your article.

Reply

10 03 2013
Anwan (11:40:20) :

I already knows that trick. Thanks for sharing it.

Reply

13 03 2013
carteles (11:25:46) :

Very interesting information for me, thanks…

Reply

20 03 2013
writers blog (08:16:05) :

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

27 03 2013
customized fat loss kyle leon (16:11:59) :

How would we change the password of admin without giving old password and other login details?

Reply

28 03 2013
menova (09:38:42) :

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

30 03 2013
http://austinalarmsystems.org/ (06:39:27) :

I faced many times that issue, but as usual call to my web host company and solved the problem.

Reply

2 04 2013
lifelock identity theft (21:02:41) :

How can we change the password without going to Email?

Reply

10 04 2013
captchaadminpanels (09:10:29) :

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

13 04 2013
Nikojen (20:51:42) :

Thanks your a wordpress legend!

Reply

16 04 2013
dubturbo (20:10:20) :

Is that possible to change the password through other Email.

Reply

19 04 2013
raf (22:30:35) :

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

25 04 2013
Cheap Mont Blanc Store (05:36:50) :

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

29 04 2013
Site (15:12:55) :

Great post on password admin reset!

Reply

30 04 2013
dr drum (04:52:13) :

Its sounds really great, definitely will try when my site is ready for launch.

Reply

2 05 2013
pflege-aus-polen24h.com (15:18:33) :

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

6 05 2013
Porter (04:51:52) :

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

11 05 2013
prestamos rapidos (09:59:45) :

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

19 05 2013
jual obat diabetes (21:25:02) :

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

19 05 2013
obat kuat (21:25:47) :

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

23 05 2013
Mobile Reviews (12:31:59) :

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

23 05 2013
SMS Collection (12:32:33) :

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

23 05 2013
raf modelleri (19:06:08) :

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

Leave a comment

You can use these tags : <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>




Rodney's Adsense-Deluxe Add ons plugged in.