2020.2

l
TCP/IP Port Number: Enter the port on which the database server expects connections.
For MySQL, this is 3306 by default.
For Microsoft SQL Server it is 1433 by default.
l
Server Schema/Table: Enter the name of the MySQL database into which the tables will
be created. The Connect standard name is "objectiflune".
l
Administrator Username: Enter the user account of a user with database administrative
rights. Administrative rights are required since tables will need to be
created/modified/dropped in the database.
If accessing a database on a different machine, the server must also be able to accept
non-local TCP connections, and the user account must also be configured to accept
remote connection. For example, the "root" MySQL user entered as root@localhost is not
allowed to connect from any other machine than the one where MySQL is installed.
l
Administrator Password: Enter the password for the above user account. For
MySQLthe appropriate password must be entered or the Connect installation will fail.
l
Use Encrypted SSLConnection checkbox: Check to enable encrypted connections to
MySQL (v5.6.43, v5.7.25, v8.0.x or later) databases using SSL.
The secure connection to MySQL is for the "objectiflune" schema.
Note
It is not in the scope of the Connect installer to configure the MySQL database
Server to accept SSL connections. This must be done prior to the installation of
Connect.
By default, the connection will not verify the server certificate
(verifyServerCertificate=false), which would allow connecting to a server using a
self-signed certificate. If such a certificate is required, then this setting can be
changed after installation within the "Database Connection preferences" on
page830 (which can be accessed from either the "Server Configuration Settings"
on page91 tool, or "Preferences" on page825 window).
l
Test Connection button: Click to verify that the information provide into previous fields is
valid by connecting to the database.
Page 44