Comment on page
MySQL
Connect & Ingest data from / to a MySQL database
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:[email protected]: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:$ sling conns set MYSQL type=mysql host=<host> user=<user> database=<database> password=<password> port=<port>
# OR use url
$ sling conns set MYSQL url=mysql://myuser:[email protected]:3306/mydatabase?tls=skip-verify
export MYSQL='mysql://myuser:[email protected]:3306/mydatabase?tls=skip-verify'
connections:
MYSQL:
type: mysql
host: <host>
user: <user>
port: <port>
database: <database>
schema: <schema>
password: <password>
MYSQL_URL:
url: "mysql://myuser:[email protected]:3306/mydatabase?tls=skip-verify"
To allow Sling to access your database, we need to create a user with the proper privileges. Please follow the steps below:
- 1.First you’ll need to login as a user with
CREATE USER
andGRANT OPTION
privileges. Create a usersling
(or whatever you prefer) by running :CREATE USER 'sling'@'%' IDENTIFIED BY '<password>'; - 2.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:CREATE SCHEMA sling;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW ON sling.* TO 'sling'@'%';
- 3.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.-- To give read access to all tables in a specific schemaGRANT SELECT ON <schema_name>.* TO 'sling'@'%';
If you are facing issues connecting, please reach out to us at [email protected] or open a Github Issue here.
Last modified 27d ago