Clickhouse 单机版

Clickhouse 单机版

yum install -y libtool
yum install -y *unixODBC*

clickhouse-client-21.7.3.14-2.noarch.rpm
clickhouse-common-static-21.7.3.14-2.x86_64.rpm
clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm
clickhouse-server-21.7.3.14-2.noarch.rpm

安装包下载地址
官方维护下载地址：https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
第三方下载地址：https://packagecloud.io/Altinity/clickhouse

cd tools
rpm -ivh *.rpm

ClickHouse各文件目录对应：
bin/ ===> /usr/bin/
conf/ ===> /etc/clickhouse-server/
lib/ ===> /var/lib/clickhouse
log/ ===> /var/log/clickhouse-server

修改config.xml配置文件
vim /etc/clickhouse-server/config.xml
<listen_host>::</listen_host>

修改user.xml配置文件 加密码 ： echo -n 123456789 | openssl dgst -sha256
<password_sha256_hex>63c10186434b22d8a65804920c494884ebad549b</password_sha256_hex>

systemctl start clickhouse-server
clickhouse-client -h 172.16.1.1 -d default -m -u default --password 123456
show databases;