Changing your WordPress admin email can be a simple process, but sometimes it requires confirming the change through the original email address. If you don’t have access to that email or don’t want to go through the confirmation process, there is a workaround. Follow these easy steps to update your admin email without confirmation and get back to managing your site in no time.
Why Change Your WordPress Admin Email?
Changing the admin email for your WordPress site is important for several reasons. It can provide added security and help you maintain control of your site in case of a hack or compromised account. Additionally, if you’ve recently changed your email address, updating it on your WordPress site ensures that you receive important notifications and updates about your website. With these benefits in mind, it’s important to know how to change your admin email efficiently and without hassle.
Preparing to Change Your WordPress Admin Email.
Before you change your WordPress admin email without confirmation, it’s important to ensure that you have access to the email address associated with your existing admin account. This is necessary because WordPress requires confirmation from the old email address before allowing you to add a new one. You should also have access to your website’s cPanel or hosting account, as this will allow you to make changes to your site’s files and database. Finally, it’s important to create a backup of your website before attempting any changes in case something goes wrong. With these preparations in place, you’re ready to move on to the next steps of the process.
Some will use their personal email address when installing WordPress and tend to change it later.
In some cases, email confirmation messages were not sent correctly resulting in the email confirmation process being stuck and not smooth. In this article, I will show you how to easily change the WordPress admin email address without confirmation.
There are two tables that hold the administrative WordPress user, wp_users and wp_options.
1) Login to your WordPress database :
# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 1454771 Server version: 5.5.68-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
2) Enter wordpress database :
MariaDB [(none)]> use linodelinuxdb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed
Change First Administrative user in wp_users table :
3) By default the first wordpress user will use ID 1 :
MariaDB [linodelinuxdb]> select * from wp_users; +----+-------------+------------------------------------+---------------+-----------------------+----------+---------------------+---------------------+-------------+--------------+ | ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name | +----+-------------+------------------------------------+---------------+-----------------------+----------+---------------------+---------------------+-------------+--------------+ | 1 | linodeuser | $xxxxxxxxxxxxxxxxxxxxxx.p0 | linodeuser | [email protected] | | 2019-12-05 15:34:30 | | 0 | linodeuser | +----+-------------+------------------------------------+---------------+-----------------------+----------+---------------------+---------------------+-------------+--------------+ 1 row in set (0.00 sec)
4) Change email address for ID 1 to new desired email address :
MariaDB [linodelinuxdb]> UPDATE wp_users SET user_email = '[email protected]' WHERE ID = 1
Change the default Administrative user in wp_options table.
5) Check default admin_email value in wp_options :
MariaDB [linodelinuxdb]> select * from wp_options WHERE option_name = 'admin_email'; +-----------+-------------+-----------------------+----------+ | option_id | option_name | option_value | autoload | +-----------+-------------+-----------------------+----------+ | 6 | admin_email | [email protected] | yes | +-----------+-------------+-----------------------+----------+
6) Change default admin_email in wp_options table :
MariaDB [linodelinuxwp]> UPDATE wp_options SET option_value = '[email protected]' WHERE option_name = 'admin_email';
7) Check the updated default admin_email value in wp_options :
MariaDB [linodelinuxdb]> select * from wp_options WHERE option_name = 'admin_email'; +-----------+-------------+-----------------------+----------+ | option_id | option_name | option_value | autoload | +-----------+-------------+-----------------------+----------+ | 6 | admin_email | [email protected] | yes | +-----------+-------------+-----------------------+----------+