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:

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

   update user set password=password('new-password') where user = 'root';

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> mysql -u root -p mysql 
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3422
Server version: 10.1.8-MariaDB-log MariaDB Server

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

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

mysql> update user set password=password('MyNewPassword') where user = 'root'; 
Query OK, 3 rows affected (0.01 sec) 
Rows matched: 3  Changed: 3  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit 
Bye