# MySQL

This Integration requires Fides Cloud or Fides Enterprise. For more information, [talk to our solutions team. (opens in a new tab)](/content/speak-with-us?utm_source=docs-site/index.html)

[MySQL (opens in a new tab)](https://mysql.org/) is a popular open-source relational database management system (RDBMS) known for its ease of use, scalability, and wide adoption in web applications.

## Prerequisites [Permalink for this section](/content/docs/integrations/databases/mysql#prerequisites/index.html)

In order to integrate with MySQL, you'll need to collect the following information from the database administrator:

- `Host`: The hostname or IP address of the server where the database is running.
- `Port`: The network port number on which the server is listening for incoming connections (default: 3306).
- `Username`: The user account used to authenticate and access the database.
- `Password`: The password used to authenticate and access the database.
- `Database`: The name of the specific database within the database server that you want to connect to.
- `SSH required`: Indicates whether an SSH tunnel is required for the connection. Enable this option if your MySQL server is behind a firewall and requires SSH tunneling for remote connections.
- `SSL Mode`: The SSL mode to use for the connection. Accepted values are: 'required', 'preferred', 'disabled', or an empty value.

## Integrating with MySQL [Permalink for this section](/content/docs/integrations/databases/mysql#integrating-with-mysql/index.html)

To integrate an existing system with MySQL:

1. Navigate to **Data map** → **View Systems** and choose the system that you want to connect to
2. Click on the **Integrations** tab.
3. Pick the vendor or system type that you want to integrate with from the **Connection type** drop-down menu.
4. Complete the required fields for the integration and click **Save**.

You may confirm your connection is working using the **Test connection** button, if desired.

To learn more, please see our guide for [Managing Integrations](/content/docs/integrations/guides/manage-integrations/index.html).

## Configuring a dataset [Permalink for this section](/content/docs/integrations/databases/mysql#configuring-a-dataset/index.html)

A dataset is required to configure an integration to this database. A dataset is a configuration file that tells Fides how to query and update data in the database. To learn more about how to create and manage datasets, please see our [Managing datasets](/content/docs/integrations/guides/datasets/index.html) guide.

An example MySQL dataset can be viewed in [Github (opens in a new tab)](https://github.com/ethyca/fides/blob/main/data/dataset/mysql_example_test_dataset.yml).

[Microsoft SQL Server](/content/docs/integrations/databases/mssql "Microsoft SQL Server"/index.html) [PostgreSQL](/content/docs/integrations/databases/postgresql "PostgreSQL"/index.html)