virtualMachinemariadb

Modify the default MariaDB administrator password

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: 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):

    • For versions lower than 10.4:

        UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
        FLUSH PRIVILEGES;
      
    • For version 10.4 and higher:

        ALTER USER root@'%' IDENTIFIED VIA mysql_native_password USING PASSWORD("NEW_PASSWORD");
        FLUSH PRIVILEGES;
      
  • Stop the MariaDB server:

      $ sudo /opt/bitnami/ctlscript.sh 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 /opt/bitnami/ctlscript.sh restart mariadb
    
  • Remove the init script:

      $ rm /tmp/mysql-init
    
Last modification May 22, 2023