Create and manage credentials

Prerequisites

• You have created a MariaDB instance.
  Check Create and manage instances for MariaDB.

List, create, view and delete service keys

This article describes how to handle credentials for your MariaDB instance. A service key is the only available form of credential that you can create for now. With a service key, you can fully authenticate yourself against your instance.

List service keys

STACKIT CLI

To get a list of all service keys for a MariaDB instance:

Flag	Description
instance-id	Instance ID of the instance you want to query

stackit mariadb credentials list --instance-id <instance-id>

You get something like the following output:

 ID
──────────────────────────────────────
ccaf719c-b954-4190-93c9-6b9ccb55c530

In this case ccaf719c-b954-4190-93c9-6b9ccb55c530 is the service key ID.

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > MariaDB.
3. Choose your instance and go to the overview.
4. In the sidebar, select Credentials.

Now you can see the list of service keys for your instance. Click on an entry in the list to see the details.

Cloud Foundry CLI

1. To use the Cloud Foundry CLI you first need to login into your STACKIT project endpoint. Read Interact with Cloud Foundry to get help logging in.

2. Create the service key with the cf command:

   cf create-service-key [service-name] [service-key]

   STACKIT Portal/CLI and Cloud Foundry cross-management is not possible

   Read Service isolation between STACKIT Portal/CLI and Cloud Foundry to get more information.

3. List the service key with the cf command:

   cf service-key [service-name] [service-key]

Create a new service key

STACKIT CLI

To create a service key for a MariaDB instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
show-password	Username of the new user		x

stackit mariadb credentials create --instance-id <instance-id>

You get the following output:

Created credentials for instance "my-mariadb-instance". Credentials ID: a0dc53d2-e6fe-49ed-aac3-5bb5f374ecc2

Username: a9s32142d4c4993ce4c2c928285e007
Password: <hidden>
Host: mad30dc70-1.data.eu01.onstackit.cloud
Port: 49271
URI: mysql://a9s32142d4c4993ce4c2c928285e007:a9s69c596f707f28fddcef2f5eb4326c58d47bbc3f9@mad30dc70-1.data.eu01.onstackit.cloud:49271/mad30dc70

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > MariaDB.
3. Choose your instance and go to the overview.
4. In the sidebar, select Credentials.
5. In the top bar, click on Create credentials.
6. Wait for the popup dialog to appear and copy all information to a safe place.

View a service key

STACKIT CLI

To get details of a service key for a MariaDB instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
service-key-id	The ID of the service key

stackit mariadb credentials describe <service-key-id> --instance-id <instance-id>

Use List service keys to get the service-key-id for the requested service key.

You get an output which is similiar to the following:

 ID       │ ccaf719c-b954-4190-93c9-6b9ccb55c530
──────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
USERNAME  │ a9s87adfa95ea09124e3034355524d2
──────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
PASSWORD  │ a9sec3e313c1038a9316c63ac19d83133167bb07aec
──────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
URI       │ mysql://a9s87adfa95ea09124e3034355524d2:a9sec3e313c1038a9316c63ac19d83133167bb07aec@mad30dc70-1.data.eu01.onstackit.cloud:49271/mad30dc70

STACKIT Portal

1. Open your project in the STACKIT Portal.

2. Navigate to Databases > MariaDB.

3. Choose your instance and go to the overview.

4. In the sidebar, select Credentials.

5. Click on the service key entry you want to view.

Delete a service key

You cannot delete a user when it owns databases or other objects. In this case, you need to delete the dependent objects first.

STACKIT CLI

To delete a service key for a MariaDB instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
service-key-id	The ID of the service key

stackit mariadb credentials delete <service-key-id> --instance-id <instance-id>

After confirmation, you get the following output:

Deleted credentials a9s87adfa95ea09124e3034355524d2 of instance "my-mariadb-instance"

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > MariaDB.
3. Choose your instance and go to the overview.
4. In the sidebar, select Credentials.
5. Click on the three dots on the right side of a user entry.
6. Click on Delete.

Cloud Foundry CLI

1. To use the Cloud Foundry CLI you first need to login into your STACKIT project endpoint. Read Interact with Cloud Foundry to get help logging in.

2. Delete the service key with the cf command:

   cf delete-service-key [service-name] [service-key]

   STACKIT Portal/CLI and Cloud Foundry cross-management is not possible

   Read Service isolation between STACKIT Portal/CLI and Cloud Foundry to get more information.