4 Implementing LSMS Query Server Security

This chapter explains the LSMS Query Server security features.

4.1 Managing User Accounts

The system administrator assigns user names and passwords.

Other than the platform-installed users, the only application and therefore the only users for the LSMS Query Server are MySQL users.

The MySQL admin user should limit additional users to only those privileges required. Refer to the Oracle MySQL Reference Manual for further details.

4.2 Configurable MySQL Port

The master port configuration on the LSMS Query Server must match the port configured in the LSMS GUI for the corresponding, mated LSMS pair. For information about setting the master port on the Query Server, refer to the LSMS Query Server Installation and Upgrade Guide.

The optional Configurable MySQL Port feature enhances the security of LSMS Query Server databases by enabling the system administrator to change the MySQL port. The port can be changed in the my.cnf file and the same port should be set for the corresponding Query Server IP address through the LSMS GUI. The MySQL port can be configured to ports 1024-65535.