clickhouse icon indicating copy to clipboard operation
clickhouse copied to clipboard

Password required for user default

Open Haseeb717 opened this issue 5 years ago • 1 comments

When I run this command Clickhouse.connection.databases it gives an error

Clickhouse::QueryError: Got status 401 (expected 200): Code: 194, e.displayText() = DB::Exception: Password required for user default (version 19.17.6.36 (official build))

how can I give password?

Haseeb717 avatar Jan 29 '20 12:01 Haseeb717

Hi, @Haseeb717 I've found this https://github.com/archan937/clickhouse/blob/6b00d0459d0633e0c7b755166b0e4e0dab044076/lib/clickhouse/connection/client.rb#L43

Try set password in connection options

options = {
              :scheme => "http",
              :host => "localhost",
              :port => 8123,
              :password => "pass"
}

Bablzz avatar Jan 30 '20 07:01 Bablzz