Vultr DocsLatest Articles

How to Manage Connection Details for Vultr Managed Databases for MySQL

Updated on November 27, 2024

Managed database connection details consist of host, port, username, password, default database, connection strings, and SSL certificates. These credentials allow you to connect to the managed databases from your favorite database client or modern programming language libraries. These include MySQL command line client (mysql), MySQL Connector/Python (mysql-connector-python), Go MySQL Driver (go-sql-driver/mysql), and PHP Data Objects (PDO).

Follow this guide to manage connection details for Vultr Managed Databases for MySQL using the Vultr Customer Portal, API, or CLI.

  • Vultr Customer Portal
  • Vultr API
  • Vultr CLI

  1. Navigate to Products and select Databases.

  2. Click the target database instance.

    Select Managed Database

  3. Navigate to Connection Details under Overview.

    Connection String

Copy Connection String

Click Copy Connection String.

Copy Connection String

Copy MySQL URL

Click Copy MySQL URL.

Copy MySQL URL

Download Signed Certificate

Click Download Signed Certificate and save the certificate.

Download Signed Certificate

  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 GET request to the Get Managed Database endpoint and specify a database ID.

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

    Visit the Get Managed Database endpoint to view additional attributes to add to your request.

  3. Copy the host, port, user, password, dbname values and use them to connect to the database from your favorite client.

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

    console 
    $ vultr-cli database list --summarize

  2. Retrieve connection details by specifying the database ID and copy the credentials.

    console 
    $ vultr-cli database get database_id

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