• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WPArena

WPArena

WPArena is a premium online resource site of WordPress and is focused on providing excellent WordPress Tutorials, Guides, Tips, and Collections.

  • News
    • Opinion
  • Tutorials
  • Reviews
    • Themes
    • Plugins
  • Comparisons
  • Collections
    • Education Themes
    • Genesis Child Themes
    • Best Responsive Themes
    • Medical WordPress Themes
    • Finance & Business Themes
    • Crowdfunding Themes
  • Resources
    • Inspiration
  • Services
WPArena » Tutorials
Tutorials

How To Change Email Address in WordPress Database

Avatar of Editorial Staff Editorial Staff Updated: March 17, 2017

change WordPress email in database
FacebookTweetPinLinkedInEmailPrint

So you have neglected your old self-hosted WordPress blog 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.

PHPMyAdmin

Next, click the Users link, note the prefix (wp_) in front of the Users link may be different than shown here.

WP Users Table in WordPress Database

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.

Admin Email Change WordPress Databasae

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 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.

This post was orginally published on: July 4, 2008 and was updated on: March 17, 2017.
FacebookTweetPinLinkedInEmailPrint

Related Stories

  • Ways to Make your WordPress site More Professional

    Ways to Make your WordPress site More Professional

  • Why WordPress Stats Stopped Working

    Why WordPress Stats Stopped Working

  • How To Keep Your eCommerce Company on Message

    How To Keep Your eCommerce Company on Message

Avatar of Editorial Staff

Editorial Staff

Editorial Staff at WPArena is a team of WordPress experts led by Jazib Zaman. Page maintained by Jazib Zaman.

Reader Interactions

Share Your Thoughts Cancel reply

Before submitting your comment, we kindly ask that you read our comment policy. Your email address will remain confidential and will not be published or shared anywhere. If you subscribe, you will receive notifications regarding new comments.

Primary Sidebar

online image editor

How To Edit an Image After Uploading – Plus Image Resize Tools

SSL certificate featured image

Most Common SSL Connection Errors And Methods To Fix Them

Recent Topics

  • Official Windows 7 Wallpapers
  • How to secure your WordPress images and content from Theft
  • Top 20 Web Designing Companies in the World
  • WP Rocket Review: Is It the Perfect Solution for WordPress Caching?
  • The Complete WordPress Security Guide 2023 – Step by Step

Footer

Top

  • Services
  • Our Themes
  • Facebook
  • Twitter
  • Linkedin

Reviews

  • Beaver Builder Review
  • Beaver Themer Review
  • WP User Frontend Pro
  • Ninja Forms Review
  • MemberPress Review

More Reviews »

Resources

  • Best WordPress Plugins
  • WordPress Permalinks Structure
  • Email Management System
  • Envato Free Files
  • Advertise
  • Write for us
  • Disclosure
  • Terms
  • Privacy
  • Contact

Copyright © 2023 · All Rights Reserved · WPArena is a Project of TechAbout LLC.
We are not affiliated with Automattic or WordPress.

  • Advertise
  • Write for us
  • Disclosure
  • Terms
  • Privacy
  • Contact
Share this ArticleLike this article? Email it to a friend!

Email sent!