Reset the WordPress administrator password
NOTE: A multi-tier environment typically consists of multiple servers. The steps below should be performed on the runtime server (the server instance running the application), which includes a mysql client. For more information on connecting via SSH, refer to the FAQ.
Use the command below to reset the administrator password from the command line.
$ mysql -u root -h DATABASEHOST -p bitnami_wordpress -e "UPDATE wp_users SET user_pass=MD5('NEWPASSWORD') WHERE ID='1';"
Remember to replace the NEWPASSWORD placeholder with your desired password and DATABASEHOST placeholder with the host where the database is running.
To obtain the hostname where the database is running, you can execute the following command
$ sudo cat /opt/bitnami/wordpress/wp-config.php | grep 'DB_HOST'
You should see an output similar to this:
In this case DATABASEHOST placeholder should be replace by “provisioner-peer”.