Installation

The exe executable to install MySQL is located here. Select "Custom" at the bottom of the "Setup Type" setup type “Custom” so that you can choose the components you want to install.

...

Once the installation is complete, the next step is proceed to the configuration. Here you can configure, among other things, the way in which communication with the database takes place. The settings you make specified here will later be used for required to build 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 Start the MySQL Command Line Client can be started. Enter your root password so that a connection and enter the root password to connect to the database can be established successfully.

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:

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

...

Add authorizations to the new MySQL user

...

To give the user the necessary rights the Add the required authorizations using the following command is used:

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

...

Determination of the connection string

The Connection String describes Connect, how contains the connection to the database can be established. This is used in the information used by the Connect Server. It is specified in the file appsettings.jsonspecified located 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 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:

"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.When connecting via Named Pipe the connection string looks like this:

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

Alternatively, you can contact Check the Connection String Documentation orient for further information.