# Connecting to MySQL Database

[MySQL ](https://aws.amazon.com/rds/mysql/)is a fully managed database service that allows users to meet databases challenges and deploy cloud-native applications using an open-source database. 

Astera offers native connectivity for MySQL databases at both source and destination points. The connectivity also extends to other objects such as *Database Lookup, SQL Query Lookup, SQL script task* in a workflow, and Database Write Strategies.

In this article, we will see how we can connect to MySQL as a database source in Astera. To establish the connection, we will be using the *Database Table Source* object.

1. Drag-and-drop the [*Database Table Source*](/dataflows/sources/database-table-source.md) object from the Toolbox onto the dataflow designer. Right-click on its header and select *Properties* from the context menu.

![](/files/IhIyUrRlpN0Pv8esApYM)

A *Database Connection* window will open.

![](/files/b1HgPE4TrH5cWKXCCPjY)

This is where you will configure the properties to establish the connection with the database.

2. On the *Database Connection* screen, you will find a drop-down list next to the *Data Provider* option.

Select *MySQL* as your data provider from this list.

![](/files/SKtUlmm24c8WVbtpnLfJ)

* Enter the required credentials for your MySQL account.

![](/files/SNEaT92lKeYu8Jg22JfT)

* *Test Connection* to make sure that the database connection is successful and click *OK*.

![](/files/aKU5Hqj8svAnU1ND54S3)

The connection to MySQL as your database provider has been successfully established. You can now pick a source table from MySQL database and use that data in your dataflow.

This concludes connecting to MySQL databases in Astera.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/connectors/connecting-to-mysql-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.