Installation

The exe to install is located here. Select "Custom" at the bottom of the "Setup Type" 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, the next step is the configuration. Here you can configure, among other things, the way in which communication with the database takes place. The settings you make here will later be used for the Connection String Used.

Creation of the MySQL user for Connect

The next step is to create a MySQL user for Connect. For this purpose the MySQL Command Line Client can be started. Enter your root password so that a connection to the database can be established successfully.

Then create the user with the following command:

CREATE USER '<username>'@'<host>' IDENTIFIED BY '<password>';

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

CREATE USER 'connect'@'%' IDENTIFIED BY 'ConnectEngine';

Give the new MySQL user the necessary rights

To give the user the necessary rights the following command is used:

GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, UPDATE ON *.* TO '<username>'@'<host>';

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

GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, UPDATE ON *.* TO 'connect'@'%';

Determination of the connection string

The Connection String describes Connect, how the connection to the database can be established. This is used in the appsettings.json specified in the Connect installation directory. What matters here is what you specified in the Connect configuration.

Regardless of these settings, the user, password and database always the same.

When you TCP/IP the connection string looks like this:

"host=127.0.0.1;port=3306;user=connect;password=ConnectEngine;database=connect;"

If you in turn Named Pipe selected, it might look like this.

"PipeName=MYSQL;user=connect;password=ConnectEngine;database=connect;"

Alternatively, you can contact the Connection String Documentation orient