ClickHouse user management

For each cluster, one administrator user is created automatically.The administrator user login is admin.The administrator user password is set when creating a cluster.After the 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 the ClickHouse administrator user 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.