Skip to content

Change the WordPress admin email via phpMyAdmin

Quick guide: Log in to your hosting control panel. Open phpMyAdmin. Select the wp_users table. Click Edit next to your username. Enter the new address in the user_email field. Click the Go button. Done!

If you cannot change your email address from the WordPress dashboard, you can do it directly in the database using the phpMyAdmin interface.

If you have a Managed WordPress hosting service from Kiravo, log in to your control panel and go to the Databases section. Click Manage next to the active database. Click the phpMyAdmin button to open the interface. Here is a full tutorial on accessing phpMyAdmin.

click-phpmyadmin-button

Click the database name from the list on the left. Look for the wp_users table. The name might include a custom prefix. Click the table name to see the list of all website users.

website users in phpMyAdmin

3. Edit the WordPress administrator profile

Section titled “3. Edit the WordPress administrator profile”

Find the administrator user row. Click the Edit button.

push the edit button next to the administrator user

Identify the user_email row. Delete the old address. Enter the new email address.

write the new email address for the WordPress administrator

Go to the bottom of the page. Click the Go button. The new WordPress user email address is now saved in the database.

click the Go button on the bottom of the phpMyAdmin page

If you need assistance, please contact the Kiravo support team.