Problem :
Upon changing the site or user email in the WordPress admin interface tonew_email_address, the following message is shown but the email is never received.
There is a pending change of your email to new_email_address. Cancel
Solution :
Firstly, cancel the change(s) in the WordPress admin interface and then access the WordPress database to execute the following SQL commands depending on your needs
To change user email:
UPDATE wp_users SET user_email = “new_email_address” WHERE wp_users.user_login = “user_login“;
To change the email address under Settings -> General -> Email Address:
UPDATE wp_options SET option_value = “new_email_address” WHERE wp_options.option_name = “admin_email”;