Change the MemSQL root password for a MemSQL node on a host (executes GRANT… SQL command), or correct memsqlctl’s record of an existing password (does not execute GRANT… SQL command)


  memsql-admin change-root-password [flags]

  -a, --all                  change the MemSQL root password of all nodes in the cluster
      --fix-secure-key       reset the secure key
  -h, --help                 help for change-root-password
      --memsql-id MemsqlID   the MemSQL ID of the node
      --password STRING      the new MemSQL root password for the node

Global Flags:
      --cache-file FILE_PATH         File path for the Toolbox node cache
  -c, --config FILE_PATH             the Toolbox configuration file path
  -j, --json                         Enable JSON output
      --parallelism int              Maximum amount of operations to be run in parallel
      --runtime-dir DIRECTORY_PATH   where to put Toolbox runtime data
      --state-file FILE_PATH         the Toolbox state file path
  -v, --verbosity count              Increase logging verbosity
  -y, --yes                          Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default


This command is interactive unless you use either the --yes or --json flags to override interactive behavior.


The change-root-password command can only be run on nodes in a running process state.

Was this article useful?