WordPress modifies the administrator’s mailbox and cannot receive the confirmation email? One trick to solve directly through the database
When maintaining a WordPress website, we often need to modify the ‘Administrator’s email address’ in the background. For security reasons, WordPress will send a confirmation email to the new address when you modify the email address, and the new mailbox will take effect only after clicking the confirmation link.
But many webmasters will have a headache:Confirmation emails can’t be received at all! Whether it is the failure of the mail sending or being blocked by the mailbox system because the server is not configured with SMTP, the final result is that the mailbox cannot be changed. This article will share how to bypass this restriction by modifying the database directly.
1. Stuck in the WordPress background of the confirmation status
When we modify and save the administrator mailbox in the background ‘Settings -> General’, a banner prompt will appear at the top of the page:‘You are about to modify the administrator’s email address to xxx@xxx.com. Cancel’. At this time, the new mailbox is not effective. If you have not received the confirmation email, it will always be stuck in this state.
2. Locate the mailbox record in the database
Since the foreground cannot be confirmed, we directly modify it from the bottom layer of the database. Log in to your database management tools (such as phpmyadmin, navicat, etc.) to find the database corresponding to the website.
We can accurately query the current storage administrator mailbox record by executing the following SQL statement:
SELECT * FROM `wp_options` WHERE `option_name` = 'admin_email' LIMIT 20;
After execution, you can clearly see option_value The field is stored in the old email address.
3. Execute SQL to force update mailbox
After finding the record, we only need to execute a simple update Statement, force the mailbox to be modified to the new address we need:
UPDATE wp_options SET option_value = 'shuijingwanwq@163.com' WHERE option_name = 'admin_email';
4. The modification is successful, and the background returns to normal
After executing the SQL statement, refresh the WordPress ‘General Settings’ page. You will be pleasantly surprised to find that the administrator’s mailbox has been successfully updated to a new mailbox, and the previous annoying confirmation prompt that ‘you are about to modify the administrator’s email address’ has also disappeared, and the problem is solved perfectly!
Summary
When WordPress fails to confirm the administrator’s mailbox due to a defective server mail function, it is directly modified wp_options table admin_email Field values are the fastest and most efficient solution. If you have the same problem, try this way!
