phpMyAdmin Life Saver: Change/Reset Password and Admin Name

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

313 comments

  1. Micheal Ethan says:

    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. http://academy.ehacking.net/courses/cissp-certification-course-training-online

    Reply

  2. c# dersleri says:

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

    Reply

  3. Menno says:

    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 😀

    Reply

  4. Luke Wright says:

    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

  5. Leta says:

    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

  6. Marina says:

    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

  7. Kristi says:

    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

  8. Pills to make my dick bigger says:

    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

  9. Sofia says:

    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

  10. Removals Company London says:

    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

  11. Todd says:

    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

  12. Helena says:

    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

  13. Kermit says:

    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

  14. Marcelo says:

    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

  15. Annmarie says:

    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

  16. Maryellen says:

    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

  17. Leonard says:

    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

  18. Leticia says:

    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

  19. natshalioni says:

    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

  20. Brandie says:

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

  21. Concetta says:

    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

  22. Green Wave Recycle says:

    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

  23. Linda says:

    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

Leave a Reply

Your email address will not be published. Required fields are marked *