1.查看版本
clickhouse-server --version
2.下载
linux机器上 wget下载,有两个安装包体积较大
wget https://packages.clickhouse.com/rpm/stable/clickhouse-server-23.2.1.2537.x86_64.rpm
wget https://packages.clickhouse.com/rpm/stable/clickhouse-keeper-dbg-23.2.1.2537.x86_64.rpm
wget https://packages.clickhouse.com/rpm/stable/clickhouse-common-static-dbg-23.2.1.2537.x86_64.rpm
wget https://packages.clickhouse.com/rpm/stable/clickhouse-client-23.2.1.2537.x86_64.rpm
wget https://packages.clickhouse.com/rpm/stable/clickhouse-common-static-23.2.1.2537.x86_64.rpm
3.安装
sudo yum install clickhouse-*
sudo rpm -ivh *.rpm
rpm -qa|grep clickhouse 查进度
cd /etc/clickhouse-server/
4.配置
开放远程访问权限config.xml,密码user.xml
::
自己学习 关闭开机自启,sudo systemctl disable clickhouse-server
; 生产环境不需要
5. 端口8123 与 9000
服务端 lsof -i :8123
客户端 9000
6.启动- clickhouse start
clickhouse start
7.启动失败
Waiting for server to start
解决方案
此次启动失败错误原因,修改配置有残留<
8.启动成功
访问服务器8123—OK.
9.登录
客户端登录
clickhouse-client -u default –password mima -mn
-m 开启多行,即可换行以分号结束
-n 一次执行多条,支持同时执行多个SQL语句 ,语句之间使用;号分割