Clickhouse单机部署

1. 下载安装clickhouse

sudo yum install -y yum-utils

sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo

sudo yum install -y clickhouse-server clickhouse-client

2.  修改用户密码

1. vim /etc/clickhouse-server/user.xml
修改
<password><password>

2. 如果想要对密码加密
# echo -n 'xxxxx' | openssl dgst -sha256
<password_sha256_hex></password_sha256_hex>

3.  修改白名单访问权限

1. 修改允许访问IP（白名单）
2. 修改文件挂载路径

4.  增加挂在目录用户权限

chown -R  clickhouse:clickhouse /home/clickhouse_data/

5.  修改时区

sudo vim /etc/clickhouse-server/config.xml

<timezone>Asia/Shanghai</timezone>

6.  启动指令 及 常用操作

sudo /etc/init.d/clickhouse-server start

systemctl start clickhouse-server
systemctl stop clickhouse-server
systemctl status clickhouse-server

7.  登录clickhouse-client

clickhouse-client --password
输入密码