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

131 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

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>




Highslide for Wordpress Plugin
Rodney's Adsense-Deluxe Add ons plugged in.