Changing a user's password in CockroachDB

Question

After creating a user, how do you change their password? Is there something in the Admin UI to do that?

Answer 1

To reset a user’s password, use the following command:

cockroach user set [username] --password [certificate flags]

You’ll then be prompted at the CLI to enter a new password.

There's no way to change a user's password via the Admin UI.

Answer 2

You need to enter cockroach sql and alter user: https://www.cockroachlabs.com/docs/stable/alter-user.html#change-a-users-password

ALTER USER <user> WITH PASSWORD '<password>'