MySQL/MariaDB Connection

Allows you to connect to a MySQL Server. You can also use this connection type to connect with the relational database management system MariaDB.

Note: MySQL 8 users require a change to their default authentication type. It must be changed from "caching_sha2_password" to "Standard".

Server mode: MySQL is running in Client-Server mode.

The embedded mode of MySQL/MariaDB is not supported.

Settings

Host The host name (DNS name) or the IP address of the server on which the database is located.
Port The TCP/IP port number used by the database.
User name User name for the connection to the database.
Password Password for the connection to the database.
Database Name, schema, or instance of the relational database.
Fetch mode For a MySQL database, you can adjust the fetch mode as follows:
  • Buffered (default): the query result is returned with buffering.
  • Full: MySQL returns the query result in one block. This is potentially slower, with higher memory consumption.
Additional JDBC parameters Optional: Database-specific parameters which are added to the generated JDBC URL.

Notes:

  • In MySQL Server, the timeout parameter (wait_timeout) has to be set sufficiently high to avoid errors during the execution of long-running jobs (e.g. "Communications link failure" error).
  • In MySQL Server 8.0 or higher after user creation privileges have to be granted in My SQL in order to use this connection type.
  • Setting the JDBC parameter "InteractiveClient" to "TRUE" might be necessary if a "Connection reset by peer" is observed.
    This parameter controls the time a connection can be idle before the server ends the connection. For more information, please see MySQL configuration documentation.

Updated August 21, 2024