Connections and credentials
Find endpoints
Open a service and select Connect. The dialog shows:
- the ClickHouse native endpoint on port
9000; - the ClickHouse HTTP endpoint on port
8123; - the ElasticQuery native and HTTP endpoints when ElasticQuery is enabled;
- the ClickStack URL when available.
Use the ClickHouse endpoint for reads, writes, and DDL. ElasticQuery endpoints are read-only.
Retrieve the default password
- Open the service.
- Select Settings.
- Select Access.
- Select Reveal beside the
defaultadministrator password.
Treat the password as a secret. Do not paste it into tickets, chat messages, or source control.
Native client
clickhouse-client \
--host <clickhouse-host> \
--port 9000 \
--user default \
--password
The client prompts for the password.
HTTP
curl --user 'default:<password>' \
'http://<clickhouse-host>:8123/?query=SELECT%20version()'
Use TLS and the externally assigned hostname when the platform exposes a secure load balancer.
Manage additional users
The default administrator can create users and grants with ClickHouse SQL.
Use separate least-privilege users for applications instead of sharing the
administrator credential.