Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using ClickHouse/ ClickHouse Permission Management/ Clearing the Passwords of the Default and ClickHouse Users
Updated on 2024-11-29 GMT+08:00
View PDF
Share

Clearing the Passwords of the Default and ClickHouse Users

After a ClickHouse cluster in normal mode is created, set the passwords of default users default and clickhouse.

  • default and clickhouse are default internal administrators of a ClickHouse cluster in normal mode (with Kerberos authentication disabled).

Clearing the Passwords of the Default and ClickHouse Users

  1. Log in to FusionInsight Manager, choose Cluster > Service > ClickHouse > Configurations > All Configurations, search for ALLOW_CLEAR_INTERNAL_ACCOUNT_PASSWORD, and change the value to true.
  2. Log in to the node where ClickHouse is installed as user root, switch to user omm, and go to the $BIGDATA_HOME/FusionInsight_ClickHouse_*/install/FusionInsight-ClickHouse-*/clickhouse/clickhouse_change_password directory.

    su - omm

    cd $BIGDATA_HOME/FusionInsight_ClickHouse_*/install/FusionInsight-ClickHouse-*/clickhouse/clickhouse_change_password

  3. Run the following command to clear the password of user default or clickhouse:

    ./change_password.sh

    In the following figure, user clickhouse is used as an example. Enter clickhouse and its password as prompted, and wait until the password is cleared.

  4. Verify that the password is cleared.

    Log in to the ClickHouse Server node and check whether the value of password in the ${BIGDATA_HOME}/FusionInsight_ClickHouse_*/*_ClickHouseServer/etc/users.xml file is empty.

    cd ${BIGDATA_HOME}/FusionInsight_ClickHouse_*/*_ClickHouseServer/etc/

    vi users.xml

    The following example shows an empty password.