一、用户创建:
创建用户组:
groupadd clickhouse
创建用户:
useradd -g clickhouse clickhouse
修改密码:
passwd clickhouse
进入文件夹:
cd clickhouse/
新建文件夹:
mkdir soft
进入文件夹:
cd soft/
上传:
把四个安装包上传到本地
链接:百度网盘 请输入提取码
提取码:0aij
二、安装:
rpm -ivh ./clickhouse-*.rpm
[root@localhost soft]# rpm -ivh ./clickhouse-*.rpm
Preparing... ########################################### [100%]
1:clickhouse-server-commo########################################### [ 25%]
2:clickhouse-common-stati########################################### [ 50%]
3:clickhouse-server ########################################### [ 75%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse
4:clickhouse-client ########################################### [100%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse
问题:
error: Failed dependencies:
glibc-common = 2.17-326.el7_9 is needed by glibc-2.17-326.el7_9.x86_64
解决:
升级glibc Centos6 升级glibc-2.17,解决Requires: libc.so.6(GLIBC_2.14)(64bit)错误解决方法 - 腾讯云开发者社区-腾讯云
三、修改配置项:
正在上传…重新上传取消config.xml正在上传…重新上传取消users.xml
四、启动:
service clickhouse-server start
REdhat 7和之后的操作系统,需要用systemctl start clickhouse-server.service启动才可以
systemctl status clickhouse-server.service查询clickhouse服务器的状态。
重启:
service clickhouse-server restart
停止:
service clickhouse-server stop
开客户端:
clickhouse-client --host 192.168.70.168 --port 9999--password abso
五、测试:
select 1
六、创建数据库及用户;
CREATE DATABASE IF NOT EXISTS abso; use abso; CREATE USER abso IDENTIFIED WITH PLAINTEXT_PASSWORD BY 'abso'; GRANT ALL ON *.* TO abso;
七、卸载;
# 卸载及删除安装文件(需root权限)
yum list installed | grep clickhouse
yum remove -y clickhouse-common-static
yum remove -y clickhouse-server-common
rm -rf /var/lib/clickhouse
rm -rf /etc/clickhouse-*
rm -rf /var/log/clickhouse-server