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
WordPress WordPress Guide
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Tagged with WordPress, WordPress Guide
Related Posts
3 Responses to "Change Old Wordpress eMail Address In Database"
Discussion Area - Leave a Comment
If you have a question about your blog please leave a link to it. Please don't ask questions like "Why don't my blog work right?" and expect an answer. I can't fix stupid.
Two links or less are welcome, any more and your comment will be spammed! Nofollow has been disabled, feel free to use your keywords or site name as your name for anchor text. Some comments may be moderated and will not appear until approved. Please submit only once.
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
Or just copy the example below and change your details.
Example - Title Of Site
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.
Wow! This really is detailed. Thanks
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…