Docker/Rancher部署ClickHouse 23.x版本，单节点模式，密码访问

准备配置文件

# my-config.xml
<clickhouse>
  <!-- Listen wildcard address to allow accepting connections from other containers and host network. -->
  <listen_host>0.0.0.0</listen_host>

  <logger>
  <level>error</level>
  </logger>
</clickhouse>

保存为my-config.xml

Docker部署命令

docker run -d --restart=always -p 18123:8123 -p 19000:9000 -v /data/clickhouse/data:/var/lib/clickhouse -v /data/clickhouse/config/my-config.xml:/etc/clickhouse-server/config.d/my-config.xml -e TZ=Asia/Shanghai -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 -e CLICKHOUSE_DB=default -e CLICKHOUSE_USER=root -e CLICKHOUSE_PASSWORD=root clickhouse/clickhouse-server:23.8

  • CLICKHOUSE_USER 账号

  • CLICKHOUSE_PASSWORD 密码

Rancher部署