nativeInstallercodedx

Modify the default MariaDB administrator password

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

Change the MariaDB root password

You can modify the MariaDB password using the following command at the shell prompt:

$ installdir/mariadb/bin/mysqladmin -p -u root password NEW_PASSWORD

Reset the MariaDB root password

NOTE: Depending on the version you have installed, you may find the MariaDB files at installdir/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 installdir/ctlscript.sh stop mariadb
    
  • Start MariaDB with the following command:

    $ sudo installdir/mariadb/bin/mysqld_safe --defaults-file=installdir/mariadb/my.cnf --init-file=/tmp/mysql-init 2> /dev/null &
    
  • Stop MariaDB and start it again:

    $ sudo installdir/ctlscript.sh stop mariadb
    $ sudo installdir/ctlscript.sh start mariadb
    
  • Remove the init script:

    $ rm /tmp/mysql-init
    
Last modification September 5, 2019