Hello @hrijhwani15,
It seems you were not able to access MySQL with those credentials. My commands try to get the password from /home/bitnami/bitnami_credentials, that is the default password for MySQL root user. So let's try this different approach:
- Verify you can access MySQL with root password. For that, execute:
mysql -u root -p
You will be prompted to introduce the root password.
It is important to know is this step was ok. Otherwise, you would need to regenerate your root password following this guide https://docs.bitnami.com/google/infrastructure/mysql/administration/change-reset-password/.
After making sure you can access MySQL as root user, you should run these commands:
sudo su
mysql -u root -p bitnami_wordpress -e "SELECT * FROM wp_users;"
- Change the password (use a new password):
mysql -u root -p bitnami_wordpress -e "UPDATE wp_users SET user_pass=MD5('MY_NEW_PASSWORD') WHERE ID='1';"
Note that MY_NEW_PASSWORD is a placeholder and needs to be changed.
- Change the email (use a new email):
mysql -u root -p bitnami_wordpress -e "UPDATE wp_users SET user_email='MY_NEW_EMAIL' WHERE ID='1';"
Note that MY_NEW_NAME is a placeholder and needs to be changed.
- Verify that the password has changed in the DB:
mysql -u root -p bitnami_wordpress -e "SELECT * FROM wp_users;"
Please note that you should execute these commands one by one, and every time you will be prompted to introduce the root password.
I am sharing a screenshot with you so you can see a similar output. In this case, I will set email david@gmail.com and password password1234.
Note as every time I need to enter the root password Enter password:, and how user_pass and user_email were modified.
Regards
