Configuring the Default ClickHouse User Password (MRS 3.1.2-LTS)

Scenarios

After a ClickHouse cluster is created, you can use the ClickHouse client to connect to the ClickHouse server. The default username is default.

This section describes how to set ClickHouse username and password after a ClickHouse cluster is successfully created.

default is the ClickHouse administrator that can be used only in clusters in normal mode (with Kerberos authentication disabled).

Notes and Constraints

This section applies only to MRS 3.1.2-LTS.

Configuring the Password of the Default Account of a ClickHouse Cluster

1. Log in to Manager and choose Cluster > Services > ClickHouse. Click the Configurations tab and then All Configurations.
2. Search for the users.default.password parameter in the search box and change its password, as shown in Figure 1.
   Figure 1 Changing the default user password
   

3. Log in to the node where the client is installed and run the following command to switch to the client installation directory.

   cdCluster client installation directory

4. Run the following command to configure environment variables:

   source bigdata_env

5. Log in to ClickHouse using the new password.

   clickhouse client --host IP address of the ClickHouse instance--user default --password

   Enter the user password.

   

   To obtain the IP address of the ClickHouse instance, choose Components > ClickHouse > Instances on the cluster details page.