Overview

You must configure MySQL accounts to enable MySQL Snaps to connect to MySQL instances.

To ensure compatibility, we recommend that you use matching versions of MySQL driver and MySQL server for configuring your account. For example, when using server version 8.0.22, ensure that the driver version is also 8.0.22. For details, see the official MySQL article on version compatibility.
To disable the mysql-cj-abandoned-connection-cleanup thread that is generated by MySQL JDBC driver, use the latest version of MySQL (later than 8.0.22), and add -Dcom.mysql.cj.disableAbandonedConnectionCleanup=true to the jcc.jvm_options in the node properties under ‘Global Properties’.

See Accounts to learn more about SnapLogic Accounts.

Snap Compatibility

Snap	MySQL Database Account	MySQL Dynamic Account

Snap	MySQL Database Account	MySQL Dynamic Account
MySQL - Bulk Load	√	√
MySQL - Delete	√	√
MySQL - Execute	√	√
MySQL - Insert	√	√
MySQL - Lookup	√	√
MySQL - Merge	√	√
MySQL - Multi Execute	√	√
MySQL - Select	√	√
MySQL - Stored Procedure	√	√
MySQL - Table List	√	√
MySQL - Update	√	√

Configuring MySQL Accounts

You can configure MySQL accounts in SnapLogic using either Designer or Manager.

Using SnapLogic Designer

Log in to SnapLogic to open the Designer.
Drag a MySQL Snap to the canvas.
Click the Snap to open the Snap's Settings.
Click the Account tab.
Click Add Account. The account types that are compatible with the selected Snap appear under Account Type. For details on Snaps and compatible Account types, see Snap Compatibility.
Select the Location where you want to create the account, and then select the Account Type.
Click Continue to open the account Settings.
Enter the required account details. For detailed guidance on how to provide information associated with each account type, use the following links:
- MySQL Dynamic Account
- MySQL Database Account
Optionally, enter additional information about this account in the Notes field of the Info tab.
Click Validate to verify the account information, if applicable.
Click Apply to complete configuring the MySQL account.

Using SnapLogic Manager

Accounts in SnapLogic are associated with Projects, and you can use accounts created in other Projects only if you have at least read access to them.

Log in to SnapLogic. Click the Manager tab.
Navigate to the Project with which to associate the new account. Click
to display the Assets dropdown, then select Account > MySQL and the target account type.

The Create Account page associated with the selected account type appears.
In Settings, enter the required account details. For detailed guidance on how to provide information associated with each account type, use the following links:
- MySQL Dynamic Account
- MySQL Database Account
Optionally, enter additional information on this account in the Notes field of the Info tab.
Click Validate to verify the account information, if applicable.
Click Apply to complete configuring the MySQL account.

Avoid updating the account credentials while Pipelines using this account are being executed. This may lead to unexpected results, including the locking of your MySQL account.