centos 7.9 单节点clickhouse-22.10.2.11 并修改数据目录_clickhouse 修改数据目录-优快云博客

本文链接：https://blog.youkuaiyun.com/m0_62999427/article/details/135899468

本文详细描述了如何下载并解压ClickHouse22.10.2.11的几个压缩包，包括客户端、静态库和服务器组件，然后进行安装、配置文件修改、用户权限设置、数据路径迁移以及安全密码设置，最后启动和连接数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

提前准备好以下

clickhouse-client-22.10.2.11-amd64.tgz

clickhouse-common-static-22.10.2.11-amd64.tgz

clickhouse-common-static-dbg-22.10.2.11-amd64.tgz

将以上压缩包进行解压缩到/data目录下

mkdir /data/clickhouse-22.10.2.11

tar -xf clickhouse-client-22.10.2.11-amd64.tgz  -C ./clickhouse-22.10.2.11/

tar -xf clickhouse-common-static-22.10.2.11-amd64.tgz  -C ./clickhouse-22.10.2.11/
tar -xf clickhouse-common-static-dbg-22.10.2.11-amd64.tgz  -C ./clickhouse-22.10.2.11/
tar -xf clickhouse-server-22.10.2.11-amd64.tgz -C ./clickhouse-22.10.2.11/

cd clickhouse-22.10.2.11

sh clickhouse-client-22.10.2.11/install/doinst.sh 

sh clickhouse-common-static-22.10.2.11/install/doinst.sh 
sh clickhouse-common-static-dbg-22.10.2.11/install/doinst.sh 
sh clickhouse-server-22.10.2.11/install/doinst.sh

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

chmod 755 /var/run/clickhouse-server/

chown -R clickhouse /var/run/clickhouse-server

sh clickhouse-server-22.10.2.11/install/doinst.sh configure
# 提示输入default默认用户名的密码
Enter password for default user:    ##按自己需求填写实际密码

sh clickhouse-client-22.10.2.11/install/doinst.sh

#此时服务已经启动起来了
systemctl status clickhouse  


#下面进行修改数据目录位置

systemctl stop clickhouse-server.service

mkdir /data/clickhouse

mv /var/lib/clickhouse  /data/

chmod 755 /etc/clickhouse-server/config.xml

vim /etc/clickhouse-server/config.xml
# 将/var/lib/clickhouse 路径 全部修改为  /data/clickhouse 
# 704行  修改时区为 <timezone>Asia/Shanghai</timezone>

vim /etc/clickhouse-server/config.d/listen.xml
<clickhouse>
    <listen_host>::</listen_host>
</clickhouse>
#改为任何人都可连接

#修改88行地址 增加默认用户default为管理员用户配置如下
<access_management>1</access_management>


#重新更改默认用户default连接密码

echo -n "需要设置的密码" | sha256sum | tr -d '-'

#将输出内容，复制粘贴到

/etc/clickhouse-server/users.d/default-password.xml


实例如下：
root@hostanme:/etc/clickhouse-server/users.d# ll
total 16
dr-x------ 2 clickhouse clickhouse 4096 Jul 24 11:53 ./
drwx------ 4 clickhouse clickhouse 4096 Jul 24 11:33 ../
-rw-r--r-- 1 clickhouse clickhouse  245 Jul 24 11:38 default-password.xml
-rw-r--r-- 1 root       root        245 Jul 24 11:53 default-password.xml.bak

root@hostanme:/etc/clickhouse-server/users.d# pwd
/etc/clickhouse-server/users.d

root@hostanme:/etc/clickhouse-server/users.d# echo -n "123" | sha256sum | tr -d '-'
a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3  

root@hostanme:/etc/clickhouse-server/users.d# vim default-password.xml

root@hostanme:/etc/clickhouse-server/users.d# cat default-password.xml
<clickhouse>
    <users>
        <default>
            <password remove='1' />
            <password_sha256_hex>a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3</password_sha256_hex>
        </default>
    </users>
</clickhouse>

=================================================
#分割线

systemctl enable clickhouse-server.service --now
systemctl status clickhouse-server.service

clickhouse-client --password
#输入密码即可连接








==================================================
#以下内容忽略

useradd -s /sbin/nologin clickhouse

chmod 755 /etc/clickhouse-server/config.xml

vim /etc/clickhouse-server/config.xml



#将这个文件内/var/lib/clickhouse  统统修改为  /data/clickhouse

mv /var/lib/clickhouse /data/

chown -R clickhouse:clickhouse /data/clickhouse

ln -s /data/clickhouse /var/lib/

echo -n 密码 | openssl dgst -sha256

#将输出的值填入到 /etc/clickhouse-server/users.d/default-password.xml

vim /etc/clickhouse-server/users.d/default-password.xml

clickhouse start

clickhouse stop

clickhouse-client --password

#输入密码即可连接