Help Center> MapReduce Service> Component Operation Guide (LTS)> Using ClickHouse> Enabling the mysql_port Configuration for ClickHouse

Updated on 2023-04-28 GMT+08:00

View PDF

Enabling the mysql_port Configuration for ClickHouse

Use the MySQL client to connect to ClickHouse.

This section applies only to MRS 3.2.0 or later.

Procedure

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.
Click the Dashboard tab, click More, and select Restart Instance; alternatively, click More and select Instance Rolling Restart.

Parent topic: Using ClickHouse

Previous topic: Configuring the Support for Transactions on ClickHouse

Next topic: Monitoring of Slow ClickHouse Query Statements and Replication Table Data Synchronization

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.