Authentication failed clickhouse

0
votes

Not able to login to clickhouse.Can any one please look into it.

root@ubuntu:~# clickhouse-client ClickHouse client version 20.8.2.3 (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.

2
authenticationclickhouse
Does this answer your question? New to ClickHouse, can't create local host - vladimir

2 Answers

1
votes

there are 3 possible reasons:

  1. network restriction (in CH auth for this user).
  2. no user with such name
  3. password is incorrect

If you just installed CH , then you can edit/remove /etc/clickhouse-server/users.d/default-password.xml . This file stores the password you entered during CH installation.

-2
votes

It's simple: do not use localhost / 127.0.0.1 but use external address