SQL Query to Update Admin Email

While your SQL query will probably do the trick, you don’t need to interface directly with the database to accomplish this.

The preferred methods would by using WordPress’ update_option() function or by running the WP-CLI command:wp option update.

Via update_option()

To override the admin email change confirmation process, add the following to your functions.php file and hit “save changes”.

update_option( 'admin_email', '[email protected]' );

Then once you’ve verified that the change worked, you can go back to your functions.php and remove the snippet.


Via WP-CLI

If you have WP-CLI installed, you can run the following command from your shell/terminal (much faster):

wp option update admin_email [email protected]

If WP-CLI is owned by root, you’ll obviously need to run it with sudo. Success will give you the following output:

Success: Updated 'admin_email' option.