How to Change the Admin Email, User Email, Blog Username and Password Through phpMyAdmin

changing admin email

Changing your WordPress administration email address should be quick and simple. Just change the old email with your email then WordPress will send a confirmation link to your new address.

damn old email
Administration email address found under Settings => General Settings

You then login to your new email, click the confirmation link and that’s it.

Your new admin email should be active now.

The process is the same when you want to change your user email which is found under “Users => Your Profile“.

user email

The Problem

The problem, however, comes when for some reason, WordPress or your webhost is unable to send the confirmation link to your new email.

Sometimes, your email provider is automatically blocking emails from your own domain.

That’s when you begin to wonder why no confirmation link is coming… and then you almost want to blame your PLR blog provider. 🙂

The good news is there’s a quick though not so comfortable way of changing your admin and user email address.

Just edit the “wp_options” table by logging in to your cPanel then simply edit your site/blogs’s database file via phpMyAdmin.

This method may look scary for many folks but let me guide you through a step by step tutorial.

Warning: This method could be uncomfortable for some specially technically-challenged folks. It can cause untoward issues to your site.

If, for some reason, you really badly needed to change your admin email through this method, make sure to make a backup of your blog/site first before proceeding.

Make sure also that your webhost provider allows you access to phpMyAdmin. Otherwise, this tutorial may not of help.

Step-by-Step Guide

Step 1: Login to your cPanel. For first time webmasters, here’s how to login.

Step 2: Take note of your site/blog’s database name.

database name

Your database name is found inside the wp-config.php file. Access this file by going to File Manager => root folder of your domain.

Step 3: Find the phpMyAdmin icon/link, usually included under DATABASES group, then click on it.

phpMyAdmin

You will be redirected into the “phpMyAdmin” page.

Step 4: If you have several databases on the list, find your database name then click on it.

find database name

Step 5: Click “wp_options” sub-table.

wp options

Step 6: Click the “Edit” link within the row where you can see “option_name = admin_email” and “option_value = the old mail” you want to replace (in this case is freezinefriends at yahoo, see screenshot below).

edit that damn row

Step 7: Now, delete the old mail and enter your new email.

replace email now

Step 8: Click the “Go” button below that table.

click go

Step 9: Verify your changes.

row changed

Step 10: Go back to your WordPress dashboard (under General Settings) and see if the email change is successful. You need to refresh your browser.

pending change

Step 11: As you can see, there’s a pending change notice below your new email address. I can’t understand why there’s a need to do that because it’s impossible to confirm that old email (freezinefriends) since you don’t have control over it.

Just click the “Cancel” button.

Step 12: If you noticed, the label has been changed from “Administration Email Address” to “Email Address” only.

email address only

Don’t be bothered by that. It will revert back to “Administration Email Address” when you update WordPress to its next version.

Changing Your User Email

Step 1: Go back to your site/blog’s database table then click on “wp_users“.

wp users

Step 2: Click the “Edit” button.

click edit user

Step 3: Delete the old mail and enter your new email.

user email

Step 4. Click the “Go” button found at the bottom of the table.

go button

Step 5: Check your Profile user email address.

email user changed

That’s it!

But don’t close your wp_user table yet. See below why.

Changing Your Username and Password

Just in case you want to change the current username and password, follow the simple steps below.

This method is also important when you forgot your admin password and can’t access the reset password feature because the admin email is not yours or you installed a PLR blog from PreMadeNiches and you want to change the old username.

Step 1: Go back and click back “Edit” button.

click back edit

Step 2: To change your username, edit the value on the user_login row. For this example, change “modern” to whatever username you want to use.

user login row

Step 3: To change the password, click the inverted triangle within the user_pass row then highlight-click “MD5

user login md5

Step 4: Now, type your new password. See screenshot below.

type new pass

Be sure MD5 is selected. See screenshot above.

Step 5. Click the “Go” button which is found at the bottom of the table.

go button

That’s it! Test your new username and password.

Summary

As a webmaster, being able to edit your site/blog’s database allow you to quickly change important credentials such as username, password, admin email and user email.

Changing even one of them can become a hassle especially if there are unnecessary roadblocks in place.

Master this basic webmaster skill and you’re on way to having more control of your own website.

You May Also Like