Control Databases User - Manage Users with doctl | Online Free DevTools by Hexmos
Manage database users with doctl. Create, list, reset passwords, and delete database users easily. Streamline your DigitalOcean database management. Free online tool, no registration required.
doctl databases user
View details for, and create, database users. More information: https://docs.digitalocean.com/reference/doctl/reference/databases/user.
- Run a
doctl databases usercommand with an access token:
doctl {{[d|databases]}} {{[u|user]}} {{command}} {{[-t|--access-token]}} {{access_token}}
- Retrieve details about a database user:
doctl {{[d|databases]}} {{[u|user]}} {{[g|get]}} {{database_id}} {{user_name}}
- Retrieve a list of database users for a given database:
doctl {{[d|databases]}} {{[u|user]}} {{[ls|list]}} {{database_id}}
- Reset the auth password for a given user:
doctl {{[d|databases]}} {{[u|user]}} {{[rs|reset]}} {{database id}} {{user_name}}
- Reset the MySQL auth plugn for a given user:
doctl {{[d|databases]}} {{[u|user]}} {{[rs|reset]}} {{database_id}} {{user_name}} {{caching_sha2_password|mysql_native_password}}
- Create a user in the given database with a given username:
doctl {{[d|databases]}} {{[u|user]}} {{[c|create]}} {{database_id}} {{user_name}}
- Delete a user from the given database with the given username:
doctl {{[d|databases]}} {{[u|user]}} {{[rm|delete]}} {{database_id}} {{user_name}}