Modify the MySQL Port for Query Servers

Since the MySQL port is a well-known port, for security purposes you can use the LSMS GUI to change the configured MySQL port for a query server.

Note: To avoid database replication issues, configure the same MySQL port for LSMS that you configure for the query server. For information about configuring the MySQL port for LSMS on the MySQL Port submenu, refer to the Configuration Guide.

For the MySQL Port for Query Servers, there are four options under Admin > QS MySQL Port as shown:

Change configured QS MySQL Port

Create
Choosing Create displays the Create QS MySQL IP:Port menu.

Create QS MySQL IP:Port

To start, all IP addresses that are configured to use default port 3306 are selectable in the QS MySQL IP field. Select an IP address, add the desired port in the QS MySQL Port field, click OK (or Apply followed by OK), and a Create Successful message is displayed.

The valid QS MySQL Port range is 1024-65535. An error message is displayed if a port outside of this range is entered.

After Create is used, the IP/Port combination is stored in a hidden file on LSMS, /usr/TKLC/lsms/tools/.qs.mysql.port. IP addresses that are assigned to particular ports are not displayed the next time Create is used.
Modify
Choosing Modify displays the Modify QS MySQL IP:Port menu.

Modify QS MySQL IP:Port

The QS MySQL IP field displays the IP addresses that were configured using Create and saved in /usr/TKLC/lsms/tools/.qs.mysql.port. You can modify the port associated with an IP address, click OK (or Apply followed by OK), and a Modify Successful message is displayed.

After Modify is used, /usr/TKLC/lsms/tools/.qs.mysql.port is updated with the modified IP/Port combination.
View
Choosing View displays the View QS MySQL IP:Port menu.

View QS MySQL IP:Port

The QS MySQL IP field displays the IP addresses that are stored in /usr/TKLC/lsms/tools/.qs.mysql.port, and the QS MySQL Port field lists the corresponding port for each IP address.
Delete
Choosing Delete displays the Delete QS MySQL IP:Port menu.

Delete QS MySQL IP:Port

Use this option to delete an IP/Port combination from /usr/TKLC/lsms/tools/.qs.mysql.port. Deleted IP/Port entries result in that LSMS subsequently connecting using default port 3306.