Generic MySQL Warehouse Setup Guidelink

These instructions are for connecting generic MySQL data warehouse as a destination. If you're using RDS, check out these more specific RDS warehouse setup instructions.

---

Allow port accesslink

Decide whether to connect to your warehouse directly or connect using an SSH tunnel.

• To connect using an SSH tunnel, follow these instructions.
• To connect directly, configure your firewall and/or other access control systems to allow incoming connections to your MySQL port (usually 3306) from Fivetran's IP.

---

Create userlink

Next, we need to create a Fivetran user in your MySQL warehouse.

Open a connection to your MySQL database using your favorite SQL tool (for example MySQL Workbench or the "mysql" command in your operating system's terminal window).

Create a Fivetran user and grant permissions by running the following SQL commands. The password should be replaced with one of your choice:

CREATE USER fivetran@'%' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW ON *.* TO fivetran@'%';

Make sure each of these commands completes without any errors. If there are errors, you may not have sufficient privileges (contact your DB admin).