1. 下载
curl https://clickhouse.com/ | sh
2.安装
sudo ./clickhouse install
# 安装过程... 设置密码
Enter password for default user:
# Password for default user is saved in file /etc/clickhouse-server/users.d/default-password.xml.
# The choice is saved in file /etc/clickhouse-server/config.d/listen.xml.
3.修改密码
# 生成密码
echo -n <需要加密的密码> | sha256sum | tr -d '-'
# 修改密码配置文件,置换密码
vi /etc/clickhouse-server/users.d/default-password.xml
4.配置
# 修改监听IP
vi /etc/clickhouse-server/config.d/listen.xml
# 修改配置文件
vi /etc/clickhouse-server/config.d/data-paths.xml
# 配置文件路径修改后,需要添加权限
chown -R clickhouse:clickhouse '/data/clickhouse'
5.启动&停止
# 启动
sudo clickhouse start
# 停止
sudo clickhouse stop
6.客户端登录
clickhouse-client --password 密码 --host localhost