Create a superadmin User
On this page
Warning
The privilege level of the Operator's admin user is designed to prohibit specific operations from being performed that could interfere with Operator automation.
As the superadmin user does not have these restrictions, it should only be used for specific operations, such as initiating disaster recovery (DR) replication or creating a database with unlimited storage.superadmin user to perform unprescribed operations (such as adding and removing leaves and/or changing engine variables, etc.
In addition, as the Operator uses the root user to manage the cluster and the root user’s password, the Operator's root password must never be changed.
Obtain the Root Password
The root user has all privileges, including those to create users and manage the cluster.root user’s password.
To obtain this secret, run the following command.
kubectl get secrets
Note that, in this secret, the password is Base64-encoded.
echo <ENCODED-VALUE> | base64 -D
Create the superadmin User
As noted earlier, while the root user’s password can be viewed, it must never be changed.
Should you need to use the root user, SingleStore recommends that you:
-
As the
rootuser, create asuperadminuser via the following SQL command.CREATE USER 'superadmin'@'%' IDENTIFIED BY '<secure-password>' -
Grant the
superadminuserrootprivileges via the following SQL command.GRANT ALL ON *.* TO 'superadmin'@'%' WITH GRANT OPTION;
Once this superadmin user has been created, obtaining the root user’s password is no longer necessary.
Last modified: March 2, 2023