Installation

The executable to install MySQL is located here. Select setup type “Custom” so that you can choose the components you want to install.

In the next step you can select your components. Select the following components:

• MySQL Servers → MySQL Server → latest version

• Applications → MySQL Workbench → latest version (Optional; Interface for MySQL; Recommended)

Once the installation is complete, proceed to the configuration. Here you can configure, among other things, the way in which communication with the database takes place. The settings specified here will later be required to build the Connection String.

Creation of the MySQL user for Connect

The next step is to create a MySQL user for Connect. Start the MySQL Command Line Client and enter the root password to connect to the database.

Then create the user with the following command:

Example for a user with the name "connect" and password "ConnectEngine". The percent sign (%) is a wildcard for all hosts:

Add authorizations to the new MySQL user

Add the required authorizations using the following command:

For the example user from above, the command would be:

Determination of the connection string

The Connection String contains the connection information used by the Connect Server. It is specified in the file appsettings.json located in the Connect installation directory. The values that need to be specified depend on the type of connection used.

When connecting via TCP/IP the connection string looks like this:

When connecting via Named Pipe the connection string looks like this:

Check the Connection String Documentation for further information.