MySQL
Connect & Ingest data from / to a MySQL database
Sling CLI Setup
The following credentials keys are accepted:
host
(required) -> The hostname / ip of the instanceuser
(required) -> he username to access the instancedatabase
(required) -> The database name of the instanceschema
(optional) -> The default schema to usepassword
(optional) -> The password to access the instanceport
(optional) -> The port of the instance. Default is3306
.ssh_tunnel
(optional) -> The URL of the SSH server you would like to use as a tunnel (examplessh://user:password@db.host:22
)ssh_private_key
(optional) -> The private key to use to access a SSH server (raw string or path to file).ssh_passphrase
(optional) -> The passphrase to use to access a SSH server.
Here are examples of setting a connection named MYSQL
. We must provide the type=mysql
property:
Environment Variable
Sling Env File YAML
See here to learn more about the sling env.yaml
file.
Database user creation
To allow Sling to access your database, we need to create a user with the proper privileges. Please follow the steps below:
First you’ll need to login as a user with
CREATE USER
andGRANT OPTION
privileges. Create a usersling
(or whatever you prefer) by running :If you are planning to load data into this connection, you need to grant the following privileges to that user so we can create tables in schema sling:
If you are planning to extract data from this connection, you need to give permission to read the tables you'd like Sling to extract.
If you are facing issues connecting, please reach out to us at support@slingdata.io, on discord or open a Github Issue here.
Last updated