Modify the default MariaDB administrator password
NOTE: A multi-tier environment typically consists of multiple servers. The steps below should be performed on the database server (the server instance hosting the database), which includes a mysql client.
Change the MariaDB root password
You can modify the MariaDB password using the following command at the shell prompt:
$ /opt/bitnami/mariadb/bin/mysqladmin -p -u root password NEW_PASSWORD
Reset the MariaDB root password
NOTE: A multi-tier environment typically consists of multiple servers. The steps below should be performed on the database server (the server instance hosting the database), which includes a mysql client.
NOTE: Depending on the version you have installed, you may find the MariaDB files at /opt/bitnami/mysql
If you don’t remember your MariaDB 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):
UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root'; FLUSH PRIVILEGES;
Stop the MariaDB server:
$ sudo service bitnami stop mariadb
Start MariaDB with the following command:
$ sudo /opt/bitnami/mariadb/bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --init-file=/tmp/mysql-init 2> /dev/null &
Restart MariaDB:
$ sudo service bitnami restart mariadb
Remove the init script:
$ rm /tmp/mysql-init