For the complete documentation index, see llms.txt. This page is also available as Markdown.

MySQL

Create a Secret for securing MySQL credentials.

Prerequisites

To create a Secret for securing MySQL credentials, you need the following information.

See Secret: Access control for who can create a Secret and how access to it is managed.

Source system requirements

  • Username: The MySQL username used to authenticate and access your MySQL database. Get this from the database admin who manages user access.

  • Password: The password for the MySQL username. The password is set when the user account is created. Get it from the MySQL admin, or retrieve it securely if forgotten.

Create a Secret for securing MySQL credentials

MySQL is a SQL database. SQL databases are centralized systems for structured data, organized into tables with a predefined schema.

To create a MySQL Secret in DataOS, you need access to the DataOS Command Line Interface (CLI) and the required permissions.

Step 1: Create a manifest file

Create a manifest file with the configuration details for your MySQL Secret.

name: ${{mysql-secret-name}}
version: v2alpha
type: secret
tags:
  - ${{tag-1}}
  - ${{tag-2}}
description: "Credentials for mysql depot"
layer: user
secret:
  type: key-value
  data:
    username: ${{mysql-username}}
    password: ${{mysql-password}}

For more information about each attribute, refer to the configurations section.

Step 2: Apply the manifest

Use the apply command to create the MySQL Secret in DataOS.

Example Usage:

Step 3: Validate the Secret

Use the get command to verify the MySQL Secret in DataOS.

Expected Output:

To list all Secrets in the DataOS environment, run the following command.

Expected Output:

Delete the Secret

To delete the MySQL Secret, use one of the following commands:

Specify the Resource type and Secret name in the delete command.

Example Usage:

Last updated

Was this helpful?