MySQL
Connect to your MySQL databases.
Getting Started
Prerequisites to create a MySQL based workflow. You will need
A source MySQL connection.
(optional) A list of tables OR SQL queries.
(optional) A destination MySQL connection.
For the source database connection, we recommend using a backup or clone with read-only permissions, instead of connecting directly to your production database.
Do not use your input database connection as an output connector. This action can result in the unintended overwriting of existing data.
Create a Connection
A mysql
connection is created using the following parameters:
Connection Creation Parameters
name
Display name of your choosing used to identify your connection within Gretel.
my-mysql-connection
username
Unique identifier associated with specific account authorized to access database.
john
password
Security credential to authenticate username.
...
host
Fully qualified domain name (FQDN) used to establish connection to database server.
myserver.example.com
port
Port number; If left empty, the default value - 3306
- will be used.
3306
database
Name of database to connect to.
mydatabase
(optional) params
Optional JDBC URL parameters that can be used for advanced configuration.
TrustServerCertificate=True&useSSL=false
Creating Connections
First, create a file on your local computer containing the connection credentials. This file should also include type
, name
, config
, and credentials
. The config
and credentials
fields should contain fields that are specific to the connection being created.
Below is an example MySQL connection:
Now that you've created the credentials file, use the CLI to create the connection
Last updated
Was this helpful?