2018.2

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.
It is 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
Administrator Password: Enter the password for the above user account. The
appropriate MySQL password must be entered or the Connect installation will fail.
l
TCP/IP Port Number: Enter the port on which the database server expects connections.
For MySQL, this is 3306 by default.
For MS SQL it is 1433 by default.
l
Database Host Name: Enter the existing database server's IP or host name.
Page 44