Create a superadmin User
On this page
The privilege level of the Operator's
admin user is designed to prohibit specific operations from being performed that could interfere with Operator automation.
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.
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
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:
rootuser, create a
superadminuser via the following SQL command.CREATE USER 'superadmin'@'%' IDENTIFIED BY '<secure-password>'
rootprivileges via the following SQL command.GRANT ALL ON *.* TO 'superadmin'@'%' WITH GRANT OPTION;
superadmin user has been created, obtaining the
root user’s password is no longer necessary.
Last modified: March 2, 2023