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

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

17 01 2014
How To Get Rid Of Lower Back Pain (02:11:52) :

Great info. I love all the posts, I really enjoyed, I would like more information about this, because it is very nice.

Reply

20 01 2014
Online Medical Equipment Store (12:31:53) :

I am very amazed when read information of this blog and i am really feels glad i had see over the blog..

Reply

27 01 2014
tanaman buah eksotis (10:10:37) :

This is great information, thanks a lot for share

Reply

31 01 2014
baju pasangan gudangcouple.com (06:58:23) :

I like to read it. Thanks for admin, I can reset it now.

Reply

Grosir Sprei Murah Reply:

Grosir Sprei Murah Berualitas yes, This is great information.

Reply

3 02 2014
subconscious mind (20:21:18) :

Great info. I love all the posts, I really enjoyed, I would like more information about this, because it is very nice.

Reply

9 02 2014
buy breakfast at tiffany's movie (18:41:12) :

or users. Speaking of users

Reply

19 02 2014
sharif (15:56:40) :

The information which I had found in this blog was really very cordial and I had liked it very much. Thanks a lot for the information…

Reply

19 02 2014
jack (18:08:06) :

hello

Reply

11 03 2014
bathroom remodel (05:06:14) :

I have a good news for who wants to remodel interior design, see now

Reply

27 04 2014
Digbijay (16:52:28) :

Yeh really nice info. I’m using on my XAMPP server too. Free VPS

Reply

29 04 2014
Johnathan (02:44:25) :

Thank you for sharing your thoughts. I really appreciate yojr efforts and I am waiting for your further write ups thank you onhce again. Here is my site – Star Wars The old Republic CC generator

Reply

14 05 2014
Linda (20:57:41) :

Thank you for your video and directions. I am not well versed in the technical aspects of WordPress.org, which is our site’s platform, but wanted to change my user name to something other than “admin”. Got as far as your screen where I was to change “admin”, and got nervous. What about the “admin” nice-name and display name (which is Linda)? Question: do you think I would be wiser to just create a new user, as suggested in a WordPress support forum? That looks less risky. BUT…will all my work really be transferred over to the new admin user? I’ve been on the site since 2011 as “admin” (although we did not have a blog on the site until last month). Sorry for so long a comment and all these questions, but you sure sound like you know what you’re doing…and I don’t!! Thanks for any help, Linda

Reply

22 05 2014
Green Wave Recycle (05:47:17) :

Thank you for sharing your thoughts. I really appreciate yojr efforts and I am waiting for your further write ups thank you onhce again.

Reply

22 05 2014
Green Wave Recycle (06:47:54) :

Great article thanks for shearing…

Reply

29 05 2014
Concetta (13:24:08) :

Excellent post. I used to be checking constantly this blog and I am inspired! Extremely helpful information specifically the remaining phase : ) I maintain such info much. I was looking for this particular information for a long time. Thank you and good luck. My blog post; fipe tabela

Reply

19 06 2014
Polly (14:39:15) :

When someone writes an paragraph he/she keeps the plan of a user in his/her mind that how a user can be aware of it. So that’s why this article is great. Thanks! my website; Christian Louboutin Sale

Reply

22 06 2014
India (12:13:19) :

This blog was… how do you say it? Relevant!! Finally I have found something which helped me. Cheers! my web site; web page; India,

Reply

25 06 2014
Brandie (18:46:54) :

I usually do not create many remarks, however i did some searching and wound up here phpMyAdmin Life Saver: Change/Reset Password and Admin Name | francescolanza.com. And I actually do have a few questions for you if it’s allright. Could it be only me or does it look like some of these responses appear like coming from brain dead individuals? :-P And, if you are posting on additional online sites, I’d like to follow everything new you have to post. Would you list of every one of all your public sites like your linkedin profile, Facebook page or twitter feed? Stop by my homepage – Maximum Shred Review

Reply

25 06 2014
Adolph (23:04:34) :

I like the valuable info you provide in your articles. I will bookmark your blog and check again here frequently. I am quite certain I will learn many new stuff right here! Best of luck for the next! Here is my blog post … Polaris QT Blower Replacement Parts Blower Top PV140010

Reply

26 06 2014
Mitchel (23:30:32) :

I think the admin of this website is really working hard in support of his web site, because here every material is quality based information. my site … Jadwal Siaran Langsung

Reply

27 06 2014
natshalioni (13:11:40) :

I found this submit being terribly educational. Thank you for broadening my expertise in this matter. No doubt their a good bit of composing likewise. Thanks davia leather

Reply

27 06 2014
Tracee (19:49:51) :

Good replies in return of this difficulty with firm arguments and telling everything regarding that. Look at my web site: freon auto

Reply

28 06 2014
Leticia (00:59:51) :

Customers should select their preferences when still inside the tool’s settings. I highhly recommend downloading Spybot Search & Destroy, a free program, to locate spyware and Lavasoft’s Adaware, also a free program, to catch whatever might be missed by Spybot. The Tanso Download Manager Plus app features unlimited downloads of various files. Feel free to visit my wepage idm

Reply

28 06 2014
Leonard (17:22:18) :

I am extremely impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it is rare to see a nice blog like this one these days. Visit my blog post – technology

Reply

29 06 2014
Kit (18:30:28) :

Hello everyone, it’s my first pay a quick visit at this website, and piece of writing is in fact fruitful for me, keep up posting such articles or reviews. Feel free to surf to my webpage Hormigonimpresomurcia.Com

Reply

30 06 2014
Jamison (19:09:43) :

Highly enbergetic blog, I lliked that bit. Will there be a part 2? Here is my web site :: Anadrol 50 Common Side Effects

Reply

2 07 2014
Maryann (20:37:43) :

The objective is to develop, redesign, or reinvent products by focusing on consumers’ needs or longings. Here’s a helpful scarf guide that describes several ways to tie and wear a scarf. Apparel fashion not only shows personality, creativity, character but most of all status of class. My web page; เสื้อผ้าคนอ้วน

Reply

3 07 2014
Maryellen (01:01:45) :

Very good site you have here but I was wondering if you knew of any community forums that cover the same topics discussed here? I’d really love to be a part of community where I can get opinions from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Bless you! Feel free to surf to my web site Melanin Skin

Reply

4 07 2014
Annmarie (20:15:55) :

Hi there I am so glad I found your site, I really found you by error, while I was browsing on Askjeeve for something else, Anyhow I am here now and would just like to say cheers for a remarkable post and a all round exciting blog (I also love the theme/design), I don’t have time to browse it all at the moment but I have saved it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the awesome jo. My web blog; Video Wallpapers windows 8

Reply

5 07 2014
Marcelo (12:08:33) :

This person does not have to be a photographer, but someone who can be there and carry any equipment would like to bring with you. You might also need to advertise in news papers and magazines to be able to draw a substantial number of clients that you can build on. The most popular paints are made by Marshall’s and are created specifically for use on photographs. Visit my web-site – savors

Reply

9 07 2014
Kermit (00:35:17) :

Aw, ths was an exceptionally gokd post. Taking the time and actual effort to make a superb article… but what can I say… I proocrastinate a lot and never seem to get nearly anything done. Check ouut my website … Twilight

Reply

9 07 2014
Helena (10:59:50) :

What’s Going down i’m new to this, I stumbled upon this I’ve discovered It positively helpful and it has aided me out loads. I hope to contribute & help other customers like its helped me. Great job. Feel free to visit my web blog … warface hack aimbot – Helena -

Reply

10 07 2014
Mackenzie (10:59:57) :

I always used to read piece of writing in news papers but now as I am a user of internet so from now I am using net for articles or reviews, thanks to web. Here is my site; Overhead garage door repair

Reply

10 07 2014
Todd (17:26:43) :

I believe what yoou coposed made a bunch of sense. But, think on this, suppose you added a little content? I ain’t saying your information is nott solid, however what if you added something to possbly get people’s attention? I mean phpMyAdmin Life Saver: Change/Reset Password and Admin Naame | francescolanza.com is a little vanilla. You should peek at Yahoo’s home page aand watch how they create post headlines to geet viewrs to open the links. You might add a related video or a related pic or two to gget people excited about what you’ve got to say. Just my opinion, it would make your posts a little livelier. My blog – jak szybko schudnąć

Reply

13 07 2014
Sabine (01:46:34) :

Backup our cause. My friend was just diagnosed with this. It is good to express our assistance! my website :: How To Read a Man Review (http://thehowtoreadamanreview.blogspot.com/)

Reply

16 07 2014
Removals Company London (19:09:38) :

Need A Moving Company? Elephant Removals is a professional House Removals Company London that prides itself in offering one of the highest standards in domestic house moves, moving home couldn’t be simpler, whether a flat removal, household Moves or just furniture, call us, and relax, don’t break your back, let the expert movers and packers take care of your property relocation needs in the UK – Worldwide.

Reply

17 07 2014
Sofia (03:45:51) :

Hiya! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa? My website goes over a lot of the same subjects as yours and I think we could greatly benefit from each other. If you’re interested feel free to shoot me an email. I look forward to hearing from you! Fantastic blog by the way! Take a look at my website: switches

Reply

22 07 2014
Vinodh (11:09:43) :

hello Happy Friendship Day Images Happy Friendship Day Friendship Day Images Happy Friendship Day Happy Friendship Day images Friendship Day Images Happy Friendship Day Happy Friendship Quotes Friendship Day Quotes :)

Reply

3 08 2014
Pills to make my dick bigger (01:56:19) :

Wow! I love all the great comments for this post! I get a lot of fun comments on my blog too. It seems very amazing that some people still think that comment span will somehow help their website! Keep up the good work. I’ll definitely be back to read more. :-)

Reply

13 08 2014
Kandi (20:27:53) :

Nice post. I was checking continuously this blog annd I am impressed! Very useful information specifically the last part :) I care for such info much. I was looking for this certain info for a long time. Thank you and best of luck. Feel free to surf to my web blog … China and Hong Kong Information on Wikipedia

Reply

13 08 2014
Alison (21:47:51) :

It’s amazing to go to ssee this wweb site andd reading the views of aall colleagues concerning thjis post, while Iam also eager off getting experience. Here is my homepage: China Information On Wikipedia

Reply

17 08 2014
Kristi (20:25:45) :

Great goods from you, man. I have consider your stuff prior to andd you are simply too fantastic. I really like what you’ve got here, really like what you’re stating and the way through whifh you say it. You are makng it entertaining and you still care for to keep it smart. I can’t wait to rdad far more from you. That is really a terrific website. my web page … tattoo downloads

Reply

20 08 2014
Marina (00:32:25) :

Included good wart relief treatments consist of garlic. You have to follow a great deal of garlic oil with every single minerals beans gives. Truth that, extensive beans won’t realize significantly with reducing a real wart. An awesome processes related to using cloves involved with garlic herb is in fact shifting a very garlic clove roughly 1/8 thinner. To talk about funny utilize duct tape in virtually any shades only one can result in. A unknown growth require to be covered from your garlic oil share. Then simply, add a section of most duct mp3 in addition to that portion having to do with garlic. You actually may used on unique duct record and furthermore garlic virtually every couple of hours accomplished final results. Involving course of action usually takes a few weeks in order to complete. You may have some sort of odor of beans ultimately finished. My web-site treatment warts

Reply

24 08 2014
Leta (07:27:14) :

I think this is among the most significant information for me. And i’m glad reading your article. But want to remark on few general things, The website style is ideal, the articles is really excellent : D. Good job, cheers Here is my web blog – gerer sa colere

Reply

1 09 2014
Luke Wright (12:13:22) :

Cheers very much to the most recent professors time estimates. I’ll consist of the item within my trainer’ersus 24-hour interval conversation. For more professors evening is quoting you may browse the locate. Teachers Day SMS

Reply

7 09 2014
Krystle (17:15:39) :

I just like the valuable information you supply for your articles. I’ll bookmark your blog and check once more right here frequently. I’m fairly certain I’ll be informed a lot of new stuff proper here! Good luck for the next! Feel free to visit my web site :: Slash World On Fire leaked album

Reply

10 09 2014
Hayden (07:49:53) :

If you are going for best contents like me, simply visdit this site all the time as it provides feature contents, thanks Here is myy webpage; Maricruz Shbi

Reply

14 09 2014
Jaclyn (00:54:27) :

Oh my goodness! Impressive article dude! Thank you, However I am having issues with your RSS. I don’t understand whhy I canbnot join it. Is there anyone else havig similar RSS problems? Anyone whho knows the solution can you kindloy respond? Thanks!! Here is my site – Find out More about england on wikipedia

Reply

14 09 2014
maximum shred ingredients (17:40:36) :

maximum shred ingredients phpMyAdmin Life Saver: Change/Reset Password and Admin Name | francescolanza.com

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.