What's the default password for the root user when the SingleStore cluster is installed?
In the SingleStore Linux deployment, SingleStore doesn't automatically set any random password during the installation (Linux), If you didn't specify a password during the SingleStore install then the root password is empty.
All that's needed to be followed is Log into the MA host and execute
memsqlcommand and you will be able to log in without the password,
In case if you have set some root password during the installation but you have forgotten the same, Then you will be able to change the root password by using the toolbox,
The recommended steps are as follows:
Step 1: Verify all hosts and nodes are online and connected to the cluster by running the sdb-admin list-nodes command.
Step 2: Execute sdb-admin change-root-password using the
--memsql-id flag with the node ID of the master aggregator.
This will update the root password on each host and make it in sync across the cluster.
Step 3: Check the status from the master aggregator ssh session by executing