> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/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/bdb-documentation/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.
* **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.
* Click the **‘Save’** option.<br>

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fth0jzJ7NJARMu3YnXBjT%2Fimage.png?alt=media\&token=2f9317c7-2469-41a3-bdee-1b388dff3ae1)

* A success message appears confirming the connection.

<div align="left"><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FL0CPyIcmAxq9THKziuqU%2Fimage.png?alt=media&amp;token=7fbc8ba0-22eb-4733-81c5-89fbde731543" alt=""></div>

* Another success message appears confirming the creation of the Data Connector.
* The newly created MySQL data connector gets added to the Data Connectors list.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FIobpZFVmA9gbDgf0goCZ%2Fimage.png?alt=media\&token=d740bf6a-8829-4eae-8632-99e170019b24)

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F9GYfsGJlW1pkqTs1578m%2Fimage.png?alt=media\&token=89a24071-c919-43f8-9ed2-abdfd608c8a5)<br>

Note: 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

&#x20;