logo
Free, Micro AI Code Reviews That Run on Git Commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, Micro AI Code Reviews That Run on Git Commit | Product Hunt git-lrc - Free, Micro AI Code Reviews That Run on Git Commit | Product Hunt

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 user command 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}}

See Also