Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using ClickHouse/ ClickHouse O&M Management/ Clearing the Passwords of Default ClickHouse Users
Updated on 2025-03-17 GMT+08:00
View PDF

Clearing the Passwords of Default ClickHouse Users

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

  • This topic is available in MRS 3.3.0 or later only.
  • default and clickhouse are default internal administrators of a ClickHouse cluster in normal mode (with Kerberos authentication disabled).

Clearing Default User Passwords

  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 is an example.