Overview

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

Note

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 -comDcom.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

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

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:
Child pages (Children Display)
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.

Note
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:
Child pages (Children Display)

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.

Warning
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.

Insert excerpt