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.