doctl-databases-user

manage database cluster users

TLDR

List database users

$ doctl databases user list [cluster_id]

Create a user

$ doctl databases user create [cluster_id] [username]

Get user info

$ doctl databases user get [cluster_id] [username]

Reset user auth password or MySQL auth plugin

$ doctl databases user reset [cluster_id] [username] [new_auth_mode]

Create a user with a specific MySQL auth plugin

$ doctl databases user create [cluster_id] [username] --mysql-auth-plugin [caching_sha2_password]

List users with custom output format

$ doctl databases user list [cluster_id] --format Name,Role

Delete a user

$ doctl databases user delete [cluster_id] [username]

SYNOPSIS

doctl databases user command [options]

doctl databases user manages users for DigitalOcean managed database clusters. Users represent authentication credentials that applications and administrators use to connect to databases.Each user has associated credentials (username and password) and potentially different privileges depending on the database engine. User management includes creating users for different applications or services, rotating credentials via password reset, and removing users when access is no longer needed.Proper user management follows security best practices: creating dedicated users for each application, regularly rotating credentials, and removing unused accounts to minimize security exposure.

PARAMETERS

--mysql-auth-plugin PLUGIN

Set MySQL authorization plugin (cachingsha2password or mysqlnativepassword). Used with create.

--acl RULES

Comma-separated Kafka ACL rules in topic:permission format. Used with create.

--opensearch-acl RULES

Comma-separated OpenSearch ACL rules in index:permission format. Used with create.

--format COLUMNS

Columns for output (e.g., Name,Role).

--no-header

Omit the header row from output.

--output FORMAT

Output format: text or json (default: text).

SUBCOMMANDS

list

Retrieve a list of database users.

create

Create a database user. New users are given a role of normal and an automatically-generated password.

get

Retrieve details about a database user.

delete

Delete a database user.

reset

Reset the auth password or the MySQL authorization plugin for a given user and return new credentials.

INSTALL

sudo dnf install doctl

sudo pacman -S doctl

sudo apk add doctl

brew install doctl

nix profile install nixpkgs#doctl