# Connecting to MySQL Database

MySQL is a fully managed database service that allows users to meet database 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 Centerprise. To establish the connection, we will be using the[ *Database Table Source*](https://documentation.astera.com/v/astera-data-stack-v8/dataflows/sources/database-table-source) object.

1. Drag-and-drop the *Database Table Source* object from the Toolbox onto the dataflow designer. Right-click on its header and select *Properties* from the context menu.

​

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F9H78Te8zHwPS8dDmZDQk%2F0.png?alt=media)

A *Database Connection* window will open.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FjFALLqXHMz6PZRGBF8SA%2F1.png?alt=media)

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://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FGVmrYOJwJTcGZYTwrjBH%2F2.png?alt=media)

* Enter the required credentials for your MySQL account.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F9HKqg1XacyGERxZHoLjf%2F3.png?alt=media)

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FlvMHnN6KZhz2ISgoKdVf%2F4.png?alt=media)

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.

To learn more about how to pick a table from a database source and specify other reading options, click [here](https://documentation.astera.com/v/astera-data-stack-v8/dataflows/sources/database-table-source).

This concludes connecting to MySQL databases in Astera.