Skip to main content

ClickHouse® User Management

Last update:

For each cluster, one administrator user is created automatically. The administrator username is admin. The administrator password is set when creating a cluster. After a cluster is created, the password cannot be viewed in the Control Panel, but it can be changed.

The administrator user can manage other cluster users via SQL queries. Read more about managing users and roles in the Access control and account management section of the ClickHouse® documentation.

Change ClickHouse® Administrator Password

  1. In the Control Panel, on the top menu, click Products and select Managed Databases.

  2. Open the Active tab.

  3. Open the database cluster page → Settings tab.

  4. In the User password block, click Change.

  5. Enter a new password or click Generate. The password must contain:

    • at least 12 characters;
    • latin letters of different cases;
    • digits;
    • special characters — !?@$%&*..

  6. Copy and save the user password — it cannot be viewed in the Control Panel after saving.

  7. Click Save.

ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.