Purpose

MySQL 5.7 or later and MariaDB 10.3 or later.

Connection fields

FieldRule and default valueExplanation
Server (name or IP address)
host
RequiredSet the value according to your service configuration.
Port
port
As configured
Default: 3306
Range: 1–65535
Set the value according to your service configuration.
Database
database
RequiredSet the value according to your service configuration.
User
username
RequiredSet the value according to your service configuration.
Encryption
tls
As configured
Default: off
off — Disabled
required — Required
verify — Required, with certificate validation
Password
secret
Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →