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 support forum

Thanks for watching and good blogging.

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



314 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.


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..


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

This is great information, thanks a lot for share


31 01 2014
baju pasangan (06:58:23) :

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


Grosir Sprei Murah Reply:

Grosir Sprei Murah Berualitas yes, This is great information.


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.


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

or users. Speaking of users


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…


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



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

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


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

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


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


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

Thank you for your video and directions. I am not well versed in the technical aspects of, 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,



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.


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

Great article thanks for shearing…


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


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


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

This blog was… how do you say it? Relevant!!
Finally I have found something which helped me.


my web site; web page; India,


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 |
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?
😛 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


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


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


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


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

Good replies in return of this difficulty with firm arguments and telling everything regarding

Look at my web site: freon auto


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


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


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


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; เสื้อผ้าคนอ้วน


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


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


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


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


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


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


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 |
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

My blog – jak szybko schudnąć


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 (


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.


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


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. 🙂


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


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


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


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


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


7 12 2014
Zandi (09:30:36) :

I’m quite pleased with the inamroftion in this one. TY!


21 01 2015
Menno (19:28:17) :

Thanks for the vid! i forgot the login information for my WordPress setup in WAMP lol … i could see the username in the database, but i was wondering how the password was encrypted 😛 MD5 option in phpmyadmin worked wonders haha 😀


28 08 2015
Alekhya (21:18:24) :

Thank you so much. I was so panicked and i was banging my head. Thank you so much for this blog and video.


26 09 2015
Major (18:33:20) :

Normally I don’t learn article on blogs, however I wish to
say that this write-up very pressured me to try and do so!
Your writing style has been surprised me. Thank you, quite nice article.

My blog post email marketing pricing


4 11 2015
Jupiter (12:39:11) :

Great info. I realize how important it is to read with comprehension. I was touched and had different perspective in life.

Impact Windows Fort Lauderdale


8 12 2015
Luxury bathrooms (16:57:44) :

Realy like this great post

Luxury Bathrooms Photos


8 12 2015
Samsung 850 Evo (17:01:19) :
14 02 2016
c# dersleri (16:25:20) :

News Yaz?l?m, En Güncel Teknoloji Haberleri , Grafik Tasar?m , Programlama , Web Tasar?m , Pc ve Mobil Hakk?nda Her?ey.


20 03 2016
iphone 7 cases (12:14:29) :

great article iphone 7 cases thank you


4 04 2016
nitesh agrawal (10:15:57) :

Thanks Your Great Post This Post Is very Helpfull With Us. Zipship


4 04 2016
nitesh agrawal (10:16:40) :
5 04 2016
Sandra Peralta (10:52:09) :

I just found this blog and have high hopes for it to continue. Keep up the great work, its hard to find good ones. I have added to my favorites. Thank You.
Server Kepon


27 07 2016
Micheal Ethan (06:13:48) :

Knowing how to reset your WordPress password from phpMyAdmin is one of the essential things you should know about because for some reason if your site is hacked, or something else, you are no longer able to login to your admin panel using the login information, and you are not able to reset the password via email, this method can be very useful. We have helped three users with the same issue therefore we have decided to do this write up.

Every WordPress blog uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using c Panel hosting.


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=""> <s> <strike> <strong>