Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using ClickHouse/ ClickHouse O&M Management/ Configuring the Default ClickHouse User Password (MRS 3.1.2-LTS)
Updated on 2024-10-09 GMT+08:00
View PDF
Share

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

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.

  • This section applies to MRS 3.1.2.
  • The default user is the ClickHouse administrator user that can be used only in normal mode (kerberos authentication is disabled).

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.