> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-center-1/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/data-center-1/data-center/data-connectors/supported-data-connectors/database-connectors/mysql.md).

# MySQL

Provide the following information to create a MySQL Data Connector:

* **Data Connector Name**: Provide a user-defined name to identify the data connector.
* **Description:** Describe about the Data Connector.
* **Username**: Enter a Username (It should be the same as given in the connection server).
* **Password:** Enter the Password (It should be the same as provided in the connection server).
* **IP/Host**: Enter database server details (from where the user wants to fetch data).
* **Port:** Provide the server port number.
* **Database Name:** Name of the database where you wish to store data.
* **SSL Type**: Select SSL or Non SSL as choices.
* **Upload Key:** Select a upload key using the drop-down menu.
* Click the ***Save*** option.

<figure><img src="https://1292667781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTXhIkVsF2MUsgjZftfJq%2Fuploads%2FVySi1rvARlT2f78DslaY%2Fimage.png?alt=media&amp;token=589d84a5-e57b-4f51-afe4-56a1d5f2772a" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*

* *The MySQL Data Connector supports multiple IP/ Host separated by commas.*
* *The MySQL Data Connector supports single Port number.*
* *The **Upload Key** field appears only if the **SSL** option is selected for the SSL Type.*

{% endhint %}

* A success message appears confirming the connection.

&#x20;    ![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FDoZZOwMXX7GM62zZnCI6%2Fimage.png?alt=media\&token=7fbc8ba0-22eb-4733-81c5-89fbde731543)

* Another success message appears confirming the creation of the Data Connector.

&#x20;    ![](https://1292667781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTXhIkVsF2MUsgjZftfJq%2Fuploads%2F304kymup3FG4KsWdJu6p%2Fimage.png?alt=media\&token=97e21257-3021-4c0f-9d4b-95fec1d4c22e)

* The newly created MySQL data connector gets added to the Data Connectors list.

<figure><img src="https://1292667781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTXhIkVsF2MUsgjZftfJq%2Fuploads%2FiIdBAfA8LAWOyVuovoYV%2Fimage.png?alt=media&amp;token=5d394c76-0b24-486a-bc5f-70e5bacb7786" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The user can use the following Environment Variables instead of the actual Username and Password to create the MySQL Data Connectors.*

* Username: @ENV.MYSQLUSERNAME
* Password: @ENV.MYSQLPASSWORD
  {% endhint %}