Updated on 2024-10-08 GMT+08:00

Enabling the mysql_port Configuration for ClickHouse

Use the MySQL client to connect to ClickHouse.

Procedure

  1. Log in to FusionInsight Manager and choose Cluster > Services > ClickHouse. Click Configurations then All Configurations. Search for the clickhouse-config-customize parameter and add the following configuration: Name: mysql_port and Value: 9004.

    The value is customizable.

    After the modification, click Save.

  2. Click the Dashboard tab, click More, and select Restart Instance; alternatively, click More and select Instance Rolling Restart.