Try changing your admin email address, waiting for a confirmation email? After 100s of attempts, only a few times, you may get the confirmation email. This article will discuss how to change the WordPress admin and user email address using PHPMyAdmin.
Page Contents
How to change Admin Email Address using phpMyAdmin.
You’ve to access phpMyAdmin to make modifications in the database of the WordPress website. You can visit the cPanel or hPanel of your hosting provider to access the phpMyAdmin. If you’re using Bitnami WordPress on Cloud, then learn here how to access phpMyAdmin on Bitnami.
Before tweaking the database, we advise you to take a backup to avoid accidental site-break or data corrupted errors. You can take the database backup using the UpdraftPlus – Backup and Restore WordPress plugin.
Select your database from phpMyAdmin. If you don’t know the WordPress database’s name, learn how to find the WordPress database name.
- Select the WordPress Database.
- Click on wp_options table.
- Now there will be a table named admin_email. Double click on the email address to change it, or click on the edit button to the admin email address.
Change the WordPress User Email Address.
User email can also be changed using the PHPMyAdmin. For this, you’ve to access the WordPress database.
- Click on wp_users and then double click on the email address to change it for the respective user_login.
This is how you can change the WordPress admin and user email address without a confirmation using PHPMyAdmin.
Final Words
In this article, we learned how to change WordPress admin or user email using the phpMyAdmin panel. But if you want to change it using WordPress dashboard and get a confirmation email, you can configure WordPress for SMTP.
I hope you liked this article. In case of any doubt or query, feel free to ask in the comment section provided below.
