phpMyAdmin Life Saver: Change or Reset Password and Admin Name for WordPress

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.

You need to upgrade your Flash Player

Bookmark It

Hide Sites

Actions

Informations

Date : 24 October 2007
Categories : Tutorials, Wordpress

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

[Reply]
4 06 2008: Sugardaddy (06:47:18) :

RESPECT bro!
You made my day

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

Hi

Thank for your video - very helpful for me!

Thanks.

J.

[Reply]
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

[Reply]
3 08 2008: Chris (19:02:57) :

Great video, good job

[Reply]
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

[Reply]
17 08 2008: Jeremiah (07:12:30) :

Thanks, that was easy.

[Reply]
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

[Reply]
Francesco Reply:
August 29th, 2008 at 10:41 am
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!

[Reply]
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.

[Reply]
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 =))

[Reply]
28 09 2008: carlson (16:46:57) :

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

[Reply]
2 10 2008: Video Blogging Tips (23:10:34) :

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

[Reply]
5 10 2008: webmaster (19:45:22) :

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

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

Graet Post! nice & helpfull
thanks

[Reply]
15 10 2008: Resetting Your Password if i forgot the password wordpress | Guide for Blogs and Wordpress (10:19:21) :

[…] Password Admin Reset (video) […]
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……

[Reply]
20 10 2008: Edgar (08:51:49) :

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

[Reply]
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.

[Reply]
23 10 2008: Gus (06:56:11) :

Awesome. Thanks a lot mate!

[Reply]
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

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

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

Thanks very much!

Scott

[Reply]
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.

[Reply]
6 11 2008: Valeria (05:54:46) :

There is no magic skill.

[Reply]
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!

[Reply]
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

[Reply]
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

[Reply]
20 11 2008: butter (08:40:04) :

thanxs for the video.. great trick

[Reply]