Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Paris Region)/ Using ClickHouse/ User Management and Authentication/ Setting the ClickHouse Username and Password
Updated on 2022-12-14 GMT+08:00
View PDF
Share

Setting the ClickHouse Username and Password

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 default internal user of ClickHouse. It is an ClickHouse administrator user available only in normal mode (kerberos authentication disabled).

Setting the ClickHouse Username and Password

  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 xxx

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