Vultr Customer Portal

1. Navigate to Products and select Databases.
2. Click the target database instance.
3. Navigate to Users & Databases and click Add New User.
4. Enter the username, select password encryption, define a strong password, and click Create New User.
5. Click Delete User to remove the user from the database or click Reset Password to change the user’s password.

Vultr API

1. List all the database instances by sending a GET request to the List Managed Databases endpoint and note the database ID. For example, 43b4c774-5dff-4ac0-a01f-78a23c2205b5.
   console

   $ curl "https://api.vultr.com/v2/databases" \
       -X GET \
       -H "Authorization: Bearer ${VULTR_API_KEY}"
   

2. Send a POST request to the Create Database User endpoint specifying the database ID and the user credentials (username, password, and encryption).
   console

   $ curl "https://api.vultr.com/v2/databases/database_id/users" \
       -X POST \
       -H "Authorization: Bearer ${VULTR_API_KEY}" \
       -H "Content-Type: application/json" \
       --data '{
           "username" : "john_doe",
           "password" : "example_password",
           "encryption" : "caching_sha2_password"
       }'
   

   Visit the Create Database User endpoint to view additional attributes to add to your request.

3. List the user details by sending a GET request to the Get Database User endpoint and specify the database ID.
   console

   $ curl "https://api.vultr.com/v2/databases/database_id/users" \
       -X GET \
       -H "Authorization: Bearer ${VULTR_API_KEY}"
   

4. Send a DELETE request to the **Delete Database User* endpoint specifying the database ID and the username to delete a user.
   console

   $ curl "https://api.vultr.com/v2/databases/database_id/users/username" \
       -X DELETE \
       -H "Authorization: Bearer ${VULTR_API_KEY}"

Vultr CLI

1. List all database instances and note the database ID. For instance, d6ac2a3c-92ea-43ef-8185-71a23e58ad8c.
   console

   $ vultr-cli database list --summarize
   

2. Add a new user by specifying a database ID, username, password and encryption method.
   console

   $ vultr-cli database user create database_id \
   --username john_doe \
   --password example_password \
   --encryption caching_sha2_password
   

3. List all database users by specifying a database ID.
   console

   $ vultr-cli database user list database_id
   

4. Delete a user from the database by specifying a database ID and a username.
   console

   $ vultr-cli database user delete database_id username
   

   Run vultr-cli database user --help to view all options.

Terraform

1. Ensure the Vultr Terraform provider is configured.
2. Create a database user with Terraform.
   terraform

   terraform {
       required_providers {
           vultr = {
           source  = "vultr/vultr"
           version = "~> 2.26"
           }
       }
   }
   
   provider "vultr" {}
   
   # Existing database assumed
   variable "database_id" { type = string }
   
   resource "vultr_database_user" "john" {
       database_id = var.database_id
       username    = "john_doe"
       password    = "example_password"
       encryption  = "caching_sha2_password"
   }
   

3. To delete the user, remove the resource block or run:
   console

   $ terraform destroy -target vultr_database_user.john