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

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

1 06 2008
mike (21:34:29) :

thanks a million, instructions were really simple and easy to follow. thanks

4 06 2008
Sugardaddy (06:47:18) :

RESPECT bro!
You made my day

15 06 2008
J. Maideen (18:31:05) :

Hi

Thank for your video - very helpful for me!

Thanks.

J.

2 08 2008
Dorothee (20:51:56) :

It is exactly what I was looking for. :) i would be glad if u visit my Artikelverzeichnis. but u need understood german :)

3 08 2008
Chris (19:02:57) :

Great video, good job

16 08 2008
RandyBrown (22:24:36) :

Nice Site. I am new here but will be visiting more often as you have done a good job.

Thanks

17 08 2008
Jeremiah (07:12:30) :

Thanks, that was easy.

18 08 2008
everything and nothing at all (05:46:33) :

[…] tried this and this. Neither have worked. When I try the first way and hit “submit”, I get a blank page. […]

29 08 2008
Fred (02:27:05) :

I have WordPress hosted on godaddy.

I someone lost my username and password.

Will the procedure you’re suggesting work for me, also?

Thanks!
Fred

Francesco Reply:

Honestly I have no idea how Godaddy website hosting is managed, if Wordpress is installed by you or by a third part script like Fantastico.

My guess is that if you can put your hands on PhpMyadmin and follow my video you can expect to change your WP password with no problem.

I would contact Godaddy support and ask if you have access to PhpMyadmin so you can edit the DB.

Always keep a back up copy of you website/database/everything and make sure you know how to restore it!

10 09 2008
Matt Serwin (21:14:08) :

You always have to write down your login and password for every site you own in a big notebook because that is the only thing I trust.

12 09 2008
Water4Gas (21:49:08) :

Matt, what is somebody finds your notebook with all your passwords and logins? That’s why all my sites have different passwords. It is not so easy to remember all of them but I feel myself secured =))

28 09 2008
carlson (16:46:57) :

Some stories about pc accessories http://tipsdevice.com

2 10 2008
Video Blogging Tips (23:10:34) :

I use Blogger. :) But that is great info for people who use WP.

5 10 2008
webmaster (19:45:22) :

Thank you for the nice post. I liked also your theme colours.

12 10 2008
You Tube Video Clips (01:20:45) :

Graet Post! nice & helpfull
thanks

15 10 2008
15 10 2008
Andrew (13:10:20) :

You little beauty..

I’ve been stuck for days trying to sort this out and the prospest of having to set up a whole new website was the only answer left to me.

Thanks a million, video simple and easy to follow. If i could pay you i would.

Thanks again……

20 10 2008
Edgar (08:51:49) :

Interesting information.
I took it!
Thank you very much!

22 10 2008
Tamil (23:48:11) :

Thank you very very much, I have no idea what went wrong with my password. I even went directly into mysql with no luck. This happened once before and I needed to reinstal wordpress.

Cheers fo this you saved my life or atleast a half day of wasted time.

23 10 2008
Gus (06:56:11) :

Awesome. Thanks a lot mate!

24 10 2008
Sam (19:09:55) :

Thank you for the great video, this will save me a lot of time when I lose my admin name again :)

25 10 2008
IT Training Scotland (15:38:06) :

Ah you have saved me some considerable stress with this information.

Thanks very much!

Scott

4 11 2008
Thomas (06:39:52) :

Messing around with the database is a very risky proposition. Then again if you can’t access the blog what does it matter? For those newbs out there who want something other than ‘Admin’ for a login, ask your host to install wordpress for you. This is at least how I changed my login name.

6 11 2008
Valeria (05:54:46) :

There is no magic skill.

13 11 2008
Yu (20:01:14) :

This sounds like music in my ears ;-) I´m not the only one who has sometimes problem to keep his passwords etc. in mind (sometimes I asked myself: silly or old?). Well I solved this problem with an old fashion method - to expand my brain I use a small book, “my second clever brain”where I write all my passwords. Guess I´m dead when I forget where this book is!

14 11 2008
Goldi (11:09:13) :

Thank you for this information and the video is also a big help but I stick to my eToken from ealaddin. Have to bite my ass if I spend money on this eToken and then I don´t use it ;-)

20 11 2008
Tutorials (00:24:12) :

Whoa, that’s a neat trick ! I didn’t know that there is an MD5 function in the phpMyAdmin itself. Thanks :)

20 11 2008
butter (08:40:04) :

thanxs for the video.. great trick

Leave a comment

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




Rodney's Adsense-Deluxe Add ons plugged in.