Generic MySQL Warehouse Setup Guide
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 access
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 user
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).