Configuring the Password of the Default Account of a ClickHouse Cluster(for MRS 3.1.2)¶
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.
Note
This section applies to MRS 3.1.2.
default is the default internal user of ClickHouse. It is an administrator user available only in normal mode (kerberos authentication disabled).
Setting the ClickHouse Username and Password¶
Log in to Manager and choose Cluster > Services > ClickHouse. Click the Configurations tab and then All Configurations.
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¶
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
Run the following command to configure environment variables:
source bigdata_env
Log in to ClickHouse using the new password.
clickhouse client --host IP address of the ClickHouse instance --user default --password xxx
Note
To obtain the service IP address of the ClickHouse instance, choose Components > ClickHouse > Instances on the cluster details page.