Reset the WordPress administrator email address

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

First, obtain the user ID for the WordPress administrator account from the command line:

$ mysql -u root -p bitnami_wordpress -e "SELECT * FROM wp_users;"

Then, use the command below to reset the administrator email address from the command line.

$ mysql -u root -h DATABASEHOST -p bitnami_wordpress -e "UPDATE wp_users SET user_email='NEW-EMAIL' WHERE ID='ADMIN-ID';"

Remember to replace the DATABASEHOST placeholder with the host where the database is running, the NEW-EMAIL placeholder with the new email address and the ADMIN-ID placeholder with the user ID obtained from the first command.

Last modification September 7, 2021