# 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*](https://documentation.astera.com/dataflows/sources/database-table-source) object from the Toolbox onto the dataflow designer. Right-click on its header and select *Properties* from the context menu.

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/KmsXTYRjqffGaUzkovYs/01-Database-Source-Context-Menu.png)

A *Database Connection* window will open.

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/40HP0EGjAKXPx9zADmLX/02-Database-Source-Connection-Window.png)

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.

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/EjrENHZr8kM8nT457Qbx/03-Data-Provider-MySQL.png)

* Enter the required credentials for your MySQL account.

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/ZfUoPKm0KDrDcDumexpJ/04-MySQL-Credentials.png)

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

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/n28C32bcJInxrltUF2oE/05-MySQL-Connection-Result.png)

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.