Product Documentation

    The password of the MariaDB root user on the appliance can be changed at any time without impacting production applications. StrongKey typically supplies a default password—BigKahuna—for this user, with instructions to change it immediately. The process to change the password is as follows:

    1. Login to the appliance as the Linux strongauth user, either on the console or through SSH over the network.

    2. If logged in on the console of the appliance and in GUI mode, open up a terminal.

    3. Start the MariaDB client application as the root user with the following command:

      mariadb -u root -p mysql
      Enter the current password when prompted.

    4. When logged in, type the following command to change the password. (replace the phrase new-password with your new password):

      set password for 'root'@localhost=password('new-password');

    5. Type the following to ensure the password changes are visible to the database engine:

      flush privileges;

    6. Exit from the MariaDB program with the exit command.

    That should change the password for the MariaDB root user. Perform Steps 1‒6 on all other SAKA servers. An example of changing the root password is shown below:

    shell> mariadb -u root -p mysql 
Enter password: 
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 199
    Server version: 11.4.2-MariaDB-log MariaDB Server

    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mysql]> set password for 'root'@localhost=password('Abcd1234!');
Query OK, 0 rows affected (0.001 sec) 

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]> exit 
Bye