MySQL

This Integration requires Fides Cloud or Fides Enterprise. For more information, talk to our solutions team. (opens in a new tab)

MySQL (opens in a new tab) 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

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

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.

Configuring a dataset Permalink for this section

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 guide.

An example MySQL dataset can be viewed in Github (opens in a new tab).

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