2021.1

Note
This option is required if MySQL Server will need to be accessed from any other
machine.
It will also be required if the MySQL database is on a separate machine to this
PlanetPress Connect installation.
Tip
This option may represent a security risk if the machine is open to the internet.
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 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".
Page 43