2019.1

Table Of Contents
We heavily recommended that your firewall is set to block access to port 3306 from
external requests.
Configuring External Database Connection
The Database Connection page appears if the supplied MySQL Product module was not
selected for installation. This page is for setting up the connection to the existing External
database.
l
Database Configuration: Select the database type to use for thePlanetPress Connect
Engine. Currently only MySQL and Microsoft SQLServer are supported.
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
Database Instance Name: Enter an existing Microsoft SQLServer's instance name.
This option only applies to existing Microsoft SQLServer instances, and not for MySQL.
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
MySQLthe appropriate password must be entered or the Connect installation will fail.
Page 44