How To Reset The MySQL Root Password?
If you don't remember your MySQL root password, you can follow the steps below to reset it to a new value:
Create a file in /home/bitnami/mysql-init with the content shown below (replace NEW_PASSWORD with the password you wish to use):
UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
"Create a file", what name should i save this file and also, should i save this file .sh or .sql ?
what type of file should this file be save in ?