Change Old Wordpress eMail Address In Database
So you have neglected your old self-hosted WordPress blog and and now you want to dust it off and start blogging once again. But you have forgotten the username and password and the email address associated with the blog is no longer active. So when you try the ‘Lost Your Password’ link on the WordPress login page the new password is getting sent into oblivion. Well there are ways to fix this and one is to reset the password in your database and that can be cumbersome and confusing. This WordPress guide will show you how to change the email address in the database associated with your WordPress Guide.
Hopefully you can still login to your hosting account and get to the phpMyAdmin panel. Once in the phpMyAdmin panel click the drop down box to view the database associated with your WordPress blog.
Next click the Users link, note the the prefix (wp_) in front of the Users link may be different than show here.
Next click the Browse link on top of the Users info shown.
Now find the user that is the administrator of the blog. It’s usually the admin account but your blog account may differ. Click the pencil icon on the left of the account to open it.
Now simply change the email address associated with the account.
Make sure the save radio button is ticked, and then click Go to change the email address.
Now you should have successfully changed the WordPress email address and should be able to use the lost password link to receive a new password. I know you may be wondering, as you are looking at the the password in the database, why not just change that? Well if you notice it is encrypted and depending on what version of WordPress you are using depends on how to generate a new MD5 password. Some may need to use an MD5 hash generator to generate a new password in an MD5 format.
Here is a post to change newer versions of WordPress passwords in the database:
How To: Resetting Your Password in WordPress
To generate a new MD5 password you can Google md5 hash password or try this site: MD5 Password Generator
Similar Posts:
- WordPress General Options Guide
- Install WordPress With Simple Scripts
- Backup WordPress Database
- Know The Proper Roles Of WordPress Users
- How To Add A Google Sitemap To A WordPress Blog
If you liked this post, feel free to leave a comment that is relevant to the post or subscribe to the feed and get future articles delivered to your feed reader.
Sorry but due to the spamming of a few all comments are moderated and will appear when approved and all drive-by comments will be deleted!
Comments
MD5 Hash password was the only hurdle for me to do that and thanks for the tip to acquire that. Can i use some script to do that. In one of my scripts i have that which converts a string into MD5 password, I have tried that but that didn’t work so I have doubts using that.
Reply
Wow! This really is detailed. Thanks
Reply
good tutorial!
Make sure you change your admin user name while your in there for security reasons, though I haven’t on my 8 or so blogs. Its a good idea too…
Reply
thankyou for the tutorial
Reply
Hi thanks Jeff this post really helped me i was worried for my blog as i forgot the pass but i helped me a lot thanks once again
Reply
Leave a comment
Drive-By comments will be deleted! Like "Thanks for sharing", "Nice post", or any other text that doesn't contribute to the discussion. If you ask a very specific question about your particular WordPress theme, it will probably be deleted. I can fix your WordPress site but for a price. If you ask a question like "Why don't my blog work right", it will be deleted. If you ask a question about your WordPress site without a leaving a link to it, it will be deleted. The point is to ask questions and or comment on the the actual content of the post, and to please use some common sense. All comments are moderated and will appear when approved. Thank you.