Configure MySQL Accounts

Overview

You must create MySQL Accounts to connect to MySQL data sources that you want to use in your pipelines.

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 -Dcom.mysql.cj.disableAbandonedConnectionCleanup=true to the jcc.jvm_options in the node properties under 'Global Properties'.

Snap-account compatibility

Snaps in the MySQL Snap Pack work with different accounts per the following table.

Snaps MySQL Database Account MySQL Dynamic Account
MySQL Bulk Load Tick Icon Tick Icon
MySQL Delete Tick Icon Tick Icon
MySQL Execute Tick Icon Tick Icon
MySQL Insert Tick Icon Tick Icon
MySQL Lookup Tick Icon Tick Icon
MySQL Merge Tick Icon Tick Icon
MySQL Multi Execute Tick Icon Tick Icon
MySQL Select Tick Icon Tick Icon
MySQL Stored Procedure Tick Icon Tick Icon
MySQL Table List Tick Icon Tick Icon
MySQL Update Tick Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Password
  • Medium + High: Username, Password
  • Low + Medium + High: Hostname, Port, Database name, Username, Password