Change WordPress Email of User in phpMyAdmin

The process to change an email for specific user in WordPress; change user's email address in database under wp_users from phpMyAdmin.

Related Articles

Purge website's NGINX cache
Find the Document Root of a Domain

Using cPanel and phpMyAdmin

1. Log into cPanel
2. Open phpMyAdmin
   
3. Open the appropriate database for site
   TIP: Find the site's database name by going to wp-config.php in the document root of the site or viewing the site/home URL in wp_options
4. Open the prefix_users table
   
5. Find the user, where there will be two options to edit
   1. Either highlight and double-click the email to edit it
   2. Or click the Edit button on the left where a new page will appear allowing edits to be made
      1. Clicking Go will save any edits made
         

NOTE: On WordPress hosting or VPS+ with NGINX installed, it's best to clear the NGINX cache after this is done.  If the site has a WordPress caching plugin running wp cache flush on the command line.

Using WP-CLI

1. Access the document root for the website in question via the command line
2. Runwp user list to find the user ID

   wp user list | grep myuser1

   Sample output:
   1   user@domain.com    myuser1    user@domain.com    2018-09-12 18:02:48    administrator

3. In the above output, the user ID is 1 (number on the far left)
4. To update the email, use the following
   

   wp user update <id> --user_email=<email>

   EXAMPLE: wp user update 1 --user_email=newuser@domain.com