Linux clickhouse单机部署

背景

仅供大家在开发环境或者本地测试可以参考，笔者记录备忘，不说废话教程如下：

安装

参见官网

sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG  
sudo yum install yum-utils  
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64  
sudo yum install clickhouse-server clickhouse-client

sudo mkdir -p /data/db/clickhouse/  
sudo mkdir -p /data/logs/clickhouse-server  
sudo mkdir -p /data/db/clickhouse/tmp/  
sudo chown -R clickhouse.clickhouse  /data/db/clickhouse  
sudo chown -R clickhouse.clickhouse /data/logs/clickhouse-server

生成密码

$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'

eEixqLK9
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

设置密码

user.xml配置密码，参见官网

<password>eEixqLK9</password> 

clickhouse启动

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

登录

• default默认账户登录

clickhouse-client

• 其他账户登录如：root

# clickhouse-client
clickhouse-client -h xxx.xxx.xx.xx -d default -m -u root --password 'eEixqLK9'

了解更多登录参数参见笔者之前的文章《clickhouse实践——clickhouse启动参数使用总结》