clickhouse的安装和配置

使用虚拟机测试, 系统为ubuntu 22.04 

一 安装

sudo apt-get install -y apt-transport-https ca-certificates dirmngr
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754
 
echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee \
    /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update
 
sudo apt-get install -y clickhouse-server clickhouse-client
# 设置密码: your_pwd
 
sudo service clickhouse-server start
# 启动
clickhouse-client --password your_pwd

二 修改配置文件: /etc/clickhouse-server/config.xml (默认只读, 修改权限可编辑)

打开注释  <listen_host>::</listen_host>

重启 sudo service clickhouse-server restart

三 DBeaver连接测试