---
title: MySQL
sidebar_position: 2
---

# MySQL Databases

This guide provides instructions for creating and connecting to a MySQL database instance on the DBaaS platform.

## Creating a MySQL Instance

To provision a new MySQL database, you must specify the following configuration parameters during creation:

*   **Database Version:** The version of MySQL you wish to run.
*   **Plan:** The resource allocation for the instance (CPU, Memory, Storage).
*   **Instance Name:** A unique, user-defined name for your database instance.
*   **Database Credentials:** The initial database name, administrative username, and a strong password.
*   **VPC (Optional):** Attach the instance to a Virtual Private Cloud (VPC) for network isolation. You can select an existing VPC or create a new one.
*   **Parameter Group (Optional):** Apply a custom parameter group to configure the MySQL engine settings.

 Once provisioning is complete, the status will change to "Running".

## Connecting to Your Database

You can connect to your running MySQL instance using any standard SQL client. The required connection details (host, port, and username) are available on the database details page.


### Command-Line Example

To connect using the `mysql` command-line tool, use the following command structure. You will be prompted for your password.

```bash
mysql -h <host> -P 3306 -u <username> -p<password>

```

Upon a successful connection, you will see the MySQL monitor welcome message.

:::warning
If you include a password directly in a connection string (not recommended), ensure any special characters are properly URL-encoded. For example, `@` should be replaced with `%40`.
:::


---