You are viewing an older version of this section. View current production version.
Change the Admin Password
Clusters managed with the SingleStore Operator must never allow the admin (root) password to be changed. The Operator uses the admin user to manage the cluster and, by extension, the admin user’s password.
Changing the admin user’s password will decouple the Operator from the SingleStore DB cluster and neither the Operator nor the cluster will continue to function as expected.
Obtain the Admin Password
The admin user has the associated privileges to create users and manage the cluster. This user is assigned a password when the SingleStore DB cluster is first created. The Operator creates a corresponding secret with the same name as the SingleStore DB cluster which is used to store the admin user’s password.
To obtain this secret, run the following command.
kubectl get secrets
Note that, in this secret, the password is Base64-encoded. To decode the password from the secret, run the following command.
echo <ENCODED-VALUE> | base64 -D
Use the Admin Account
As noted earlier, while the admin user’s password can be viewed, it must never be changed.
Should you need to use the admin (root) account, SingleStore recommends that you:
As the admin (root) user, create a
superadminuser via the following SQL command.
CREATE USER 'superadmin'@'%' IDENTIFIED BY '<secure-password>'
superadminuser admin (root) privileges via the following SQL command.
GRANT ALL ON *.* TO 'superadmin'@'%' WITH GRANT OPTION;
superadmin user has been created, obtaining the admin user’s password is no longer necessary.