Reset the WordPress administrator email address

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 May 22, 2023