How to Change WordPress Admin Email Without Confirmation

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   | linodeuser@gmail.com |          | 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@linodelinux.com' WHERE ID = 1

Change the default Administrative user in wp_options table.

5) Check default admin_email value in wp_options :

Change WordPress Admin Email Without Confirmation

MariaDB [linodelinuxdb]> select * from wp_options WHERE option_name = 'admin_email';
+-----------+-------------+-----------------------+----------+
| option_id | option_name | option_value          | autoload |
+-----------+-------------+-----------------------+----------+
|         6 | admin_email | old_admin@gmail.com   |  yes     |
+-----------+-------------+-----------------------+----------+

6) Change default admin_email in wp_options table :

MariaDB [linodelinuxwp]> UPDATE wp_options SET option_value = 'linodeuser@gmail.com' WHERE option_name = 'admin_email';

7) Check the updated default admin_email value in wp_options :

Change WordPress Admin Email Without Confirmation

MariaDB [linodelinuxdb]> select * from wp_options WHERE option_name = 'admin_email';
+-----------+-------------+-----------------------+----------+
| option_id | option_name | option_value          | autoload |
+-----------+-------------+-----------------------+----------+
|         6 | admin_email | linodeuser@gmail.com  |  yes     |
+-----------+-------------+-----------------------+----------+

Leave a Comment