doctl databases user reset
Generated on 23 Jun 2025
from doctl
version
v1.131.0
Usage
doctl databases user reset <database-cluster-id> <user-name> <new-auth-mode> [flags]
Aliases
rs
Description
Resets the auth password or the MySQL authorization plugin for a given user and returns the user’s new credentials. When resetting MySQL auth, valid values for <new-auth-mode>
are caching_sha2_password
and mysql_native_password
.
Example
The following example resets the auth plugin for the user with the username example-user
for a database cluster with the ID ca9f591d-f38h-5555-a0ef-1c02d1d1e35
to mysql_native_password
:
doctl databases user reset ca9f591d-f38h-5555-a0ef-1c02d1d1e35 example-user mysql_native_password
Flags
Option | Description |
---|---|
--help , -h |
Help for this command |
Related Commands
Command | Description |
---|---|
doctl databases user | Display commands for managing database users |
Global Flags
Option | Description |
---|---|
--access-token , -t |
API V2 access token |
--api-url , -u |
Override default API endpoint |
--config , -c |
Specify a custom config file Default: |
--context |
Specify a custom authentication context name |
--http-retry-max |
Set maximum number of retries for requests that fail with a 429 or 500-level error
Default: 5 |
--http-retry-wait-max |
Set the minimum number of seconds to wait before retrying a failed request
Default: 30 |
--http-retry-wait-min |
Set the maximum number of seconds to wait before retrying a failed request
Default: 1 |
--interactive |
Enable interactive behavior. Defaults to true if the terminal supports it (default false)
Default: false |
--output , -o |
Desired output format [text|json] Default: text |
--trace |
Show a log of network activity while performing a command Default: false |
--verbose , -v |
Enable verbose output Default: false |