Available since MemSQL Ops version 4.0.31.

Update the root password for a MemSQL 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 MemSQL node.

positional arguments:
  memsql_id             The ID of the MemSQL node.

optional arguments:
  --settings-file SETTINGS_FILE
                        A path to a MemSQL Ops settings.conf file. If not set,
                        we will use the file in the same directory as the
                        MemSQL Ops binary.
  --async               If this option is true, we will exit without waiting
                        for MemSQL Ops to finish updating the root password.
  --no-prompt           Skip interactive prompts if ID is not provided. This
                        should be used for non-interactive scripts and
                        automation.
  -p [PASSWORD], --password [PASSWORD]
                        The password to use for the root user on the MemSQL
                        node. Leave blank to read the MEMSQL_PASSWORD
                        environment variable, or have a password prompt if
                        MEMSQL_PASSWORD is not set. Note: empty string value
                        clears the password for root.
  --no-confirmation     If this option is specified, we will update the root
                        password without prompting for confirmation.
  --force               If this is true, we will set the password in MemSQL
                        Ops even if we cannot currently connect to MemSQL.

Notes

• To configure the password on all nodes in a MemSQL 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 for more information.

• If you are running MemSQL Ops 6.0.10 or older and/or MemSQL 6.0 or older, see the previous version of this topic for additional instructions when running memsql-update-root-password.

Was this Article Helpful?

Thanks For Your Feedback!