MEMSQL-UPDATE-ROOT-PASSWORD
On this page
Available since MemSQL Ops version 4.
Update the root password for a SingleStoreDB node.
Usage
usage: memsql-ops memsql-update-root-password [--settings-file SETTINGS_FILE][--async] [--no-prompt][-p [PASSWORD]][--no-confirmation] [--force][memsql_id]Update the root password for a SingleStoreDB node.positional arguments:memsql_id The ID of the SingleStoreDB node.optional arguments:--settings-file SETTINGS_FILEA path to a MemSQL Ops settings.conf file. If not set,we will use the file in the same directory as theMemSQL Ops binary.--async If this option is true, we will exit without waitingfor MemSQL Ops to finish updating the root password.--no-prompt Skip interactive prompts if ID is not provided. Thisshould be used for non-interactive scripts andautomation.-p [PASSWORD], --password [PASSWORD]The password to use for the root user on the SingleStoreDBnode. Leave blank to read the MEMSQL_PASSWORDenvironment variable, or have a password prompt ifMEMSQL_PASSWORD is not set. Note: empty string valueclears the password for root.--no-confirmation If this option is specified, we will update the rootpassword without prompting for confirmation.--force If this is true, we will set the password in MemSQLOps even if we cannot currently connect to SingleStoreDB.
Notes
-
To configure the password on all nodes in a SingleStoreDB cluster, run:
memsql-ops memsql-list -q | xargs -n 1 memsql-ops memsql-update-root-password --no-confirmation -p <password> -
When using MemSQL 6.
7 and MemSQL Ops 6. 0. 11 or later, changing the root
password is an online operation for both aggregators and leaves; otherwise, it should be considered an offline operation.See [Configuring the root password]({{< relref /v6.
>}}) for more information.7/guides/security/general/securing-memsql. md#configuring-the-root-password -
If you are running MemSQL Ops 6.
0. 10 or older and/or MemSQL 6. 0 or older, see the [previous version]({{< relref /v6.
>}}) of this topic for additional instructions when running0/reference/memsql-ops-cli-reference/memsql-node-and-cluster-management/memsql-update-root-password. md memsql-update-root-password
.
Last modified: April 25, 2023