Change administrator email from the Database

This entry will be brief.

Sometimes we must change the administration e-mail of a web, that one that we find in Settings -> General, but as it shows us, it will not change until it is verified in the previous mail.

Change e-mail administrator

This is all very well for security reasons, but what happens if we do not have access to the previous email?, we have to change it in the database.

And this is where you will find a lot of tutorials on the web that will tell you to change the admin_email field in the wp_options table in the database.

But it turns out that if you actually do that, you will end up with the same confirmation screen and, therefore, the same previous problem:

Confirmation of change of administrator e-mail

And you will have to change it both in admin_email and new_admin_email of the table wp_options (remember to change the prefix wp_ by the corresponding prefix of your WordPress installation).

You can display both fields with this query:

SELECT * FROM wp_options WHERE option_name LIKE '%admin_email%';

And there change both emails.

change sql admin email

Short, isn’t it?

Leave a Comment