Search code examples
clickhouse

New to ClickHouse, can't create local host

I'm new to clickhouse and trying to get started. I've installed all the packages needed to be able to use it on my computer (ubuntu 16.04) but when I use the clickhouse-client command I get the following:

ClickHouse client version 20.3.4.10 (official build).
Connecting to localhost:9000 as user default.
Code: 516. DB::Exception: Received from localhost:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name.

Do anyone know what I should do?

Solution

  • Find the Password here:

    Open the terminal and run:

    sudo nano /etc/clickhouse-server/users.d/default-password.xml

    Source : https://clickhouse.tech/docs/en/operations/configuration-files/