====== Database user configuration ======
{{indexmenu_n>5}}

By default, the ClickHouse database connection uses the user **default** with an empty password. 

If necessary, you can set a username and password.

To do this, on the server where QoE Stor is installed, in the file /etc/clickhouse-server/users.xml under the <users> section:

  - Set a password for the **default** user {{ :dpi:qoe_analytics:implementation_administration:configuration_setup:db_user_and_password:ch_db_default_pass.png?400 |}}
  - Add a new user (for example, <vasexpert>) and set the parameters **networks**, **profile**, and **quota** the same as for the default user {{ :dpi:qoe_analytics:implementation_administration:configuration_setup:db_user_and_password:ch_db_adduser.png?400 |}}

In the file /etc/clickhouse-client/config.xml under the <config> section, add the parameters <user> and <password>  {{ :dpi:qoe_analytics:implementation_administration:configuration_setup:db_user_and_password:ch_db_client_adduser.png?400 |}}

In dpiui2, in the configuration section, set the username and password for connecting to the ClickHouse database {{ :dpi:qoe_analytics:implementation_administration:configuration_setup:db_user_and_password:ch_db_dpui2_adduser.png?400 |}}