This section describes how to install the MySQL database server, after which you can create and initialize the databases and their users.
NOTE: MySQL 5.7 Community is not supported on CentOS/RHEL 8.1.
- You must install a supported version of the database. For more information on supported versions of this database type, see System Requirements in the Planning Guide.
- The installing user must have write permissions to the directory from which the commands are executed.
The installing user must have sudo privileges.
NOTE: The database client should already be installed. See Install Database Client for MySQL.
Acquire MySQL Java driver
The MySQL Java driver is not packaged with the Alteryx installer. If you are installing the Alteryx databases into MySQL, please acquire the following driver files.
This file can be downloaded from the following locations:
This file needs to be installed in the following locations on the Alteryx node:
This file can be downloaded from here:
This file needs to be installed in the following location:
MySQL log_bin_trust_function_creators is required for installation
When the Alteryx databases are hosted on MySQL, for the installation process, you must enable the
log_bin_trust_function_creators flag. When enabled, this flag allows MySQL to trust the creators of stored functions to not write unsafe events to the binary log.
NOTE: This flag is a global flag in MySQL. It is only required during the installation process and can be disabled afterward.
Select Configuration File
If you are installing the database in a MySQL instance, a separate base configuration has been provided. This configuration file is stored in the following location:
To use MySQL, you should back up the default configuration file and then copy the MySQL version in its place:
If you have already applied configuration changes to
trifacta-conf.json through the above file or the Admin Settings page, these changes are lost when the following steps are performed. You must manually migrate those changes over or apply the MySQL changes manually.
NOTE: The following distributions and commands are for MySQL Community Server 5.7.
|O/S Distribution||URL||Package Name|
|O/S Distribution||URL||Package Name|
For CentOS 7.x:
For CentOS 8.x:
For Red Hat Enterprise Linux 7.x: See CentOS 7 above.
For Red Hat Enterprise Linux 8.x: See CentOS 8 above.
For Ubuntu 16.04:
For Ubuntu 18.04:
Acquire Port Information
After you have completed the installation, you must acquire the port information for each database from the following locations on the Alteryx node. These port numbers need to be applied inside the Designer Cloud Powered by Trifacta platform.
CentOS/RHEL (MySQL 5.7):
The default port is
Ubuntu (MySQL 5.7) : Not supported.
Configure MySQL Timezone
If your MySQL databases are in a different timezone from the Alteryx node, you must configure the timezone value for each database, so that it can be inserted as part of the connection string.
NOTE: If the Alteryx node and your MySQL databases are co-located in the same timezone, you can skip this section.
In the Admin Settings page, these parameters are in the following form:
For each database, insert the appropriate timezone value. For more information on supported values, see the documentation for your MySQL product.
Enable SQL Mode
When using MySQL, you must enable the following modes:
NOTE: These modes are enabled by default in deployments of upstream MySQL. They must be enabled manually if you are installing the databases in a hosted environment, such as Amazon RDS or Azure MySQL. Refer to your MySQL host's documentation.
To verify if these modes are enabled, please execute the following query:
The two required values should be listed in the query output.
For more information on enabling these modes, see https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html.
Update MySQL Password Policy
NOTE: This section only applies to CentOS and RHEL platforms only where MySQL is the installed database.
By default, MySQL enforces a stricter password policy on database passwords. If you prefer to set your own passwords outside of this policy, you must lower the password policy. Please complete the following steps:
This page has no comments.