Modify the MySQL administrator password
Change the MySQL root password
You can modify the MySQL password using the following command at the shell prompt. Replace the NEW_PASSWORD placeholder with the actual password you wish to set.
$ /opt/bitnami/mysql/bin/mysqladmin -p -u root password NEW_PASSWORD
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 /tmp/mysql-init with the content shown below (replace NEW_PASSWORD with the password you wish to use).
If your stack ships MySQL v5.7.x or MySQL v8.x, use this content:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD';
If your stack ships MySQL v5.6.x or earlier, use this content:
UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root'; FLUSH PRIVILEGES;
TIP: Check the MySQL version with the command
/opt/bitnami/mysql/bin/mysqladmin --version
or/opt/bitnami/mysql/bin/mysqld \--version
Stop the MySQL server:
$ sudo /opt/bitnami/ctlscript.sh stop mysql
Start MySQL with the following command:
If your stack ships MySQL v8.x, use this command:
$ sudo /opt/bitnami/mysql/bin/mysqld_safe --pid-file=/opt/bitnami/mysql/data/mysqld.pid --datadir=/opt/bitnami/mysql/data --init-file=/tmp/mysql-init --lower_case_table_names=1 2> /dev/null &
If your stack ships an older version of MySQL, use this command:
$ sudo /opt/bitnami/mysql/bin/mysqld_safe --pid-file=/opt/bitnami/mysql/data/mysqld.pid --datadir=/opt/bitnami/mysql/data --init-file=/tmp/mysql-init 2> /dev/null &
Restart the MySQL server:
$ sudo /opt/bitnami/ctlscript.sh restart mysql
Remove the script:
$ rm /tmp/mysql-init