1. centos7下卸载删除:

yum list installed | grep clickhouseyum remove -y clickhouse-common-staticyum remove -y clickhouse-server-commonrm -rf /var/lib/clickhouserm -rf /etc/clickhouse-*rm -rf /var/log/clickhouse-server

2. centos7装置clickhouse

2.1 装置:

sudo yum install -y yum-utilssudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.reposudo yum install -y clickhouse-server clickhouse-clientsudo /etc/init.d/clickhouse-server startclickhouse-client # or "clickhouse-client --password" if you set up a password.

2.2 查问以后版本:

SELECT version()

Query id: 8c3867fc-df94-456e-9b2c-863459a6d03b

┌─version()─┐
│ 22.12.3.5 │
└───────────┘

1 row in set. Elapsed: 0.002 sec.

3. 创立用户

创立一个新用户 niewj/246810 有所有权限:

vim /etc/clickhouse-server/users.xml

3.1 配置批改access_management

<!-- User can create other users and grant rights to them. -->88             <access_management>1</access_management>
重启
/etc/init.d/clickhouse-server restart

如果不批改就创立, 会报错如下:

CREATE USER niewj IDENTIFIED WITH plaintext_password BY '246810' HOST ANY DEFAULT ROLE ALL;
CREATE USER zhili IDENTIFIED WITH plaintext_password BY '246810' HOST ANY DEFAULT ROLE ALLQuery id: 3b1f8e98-5bc7-4be9-bc1f-70b05c9e1f250 rows in set. Elapsed: 0.003 sec. Received exception from server (version 22.12.3):Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: default: Not enough privileges. To execute this query it's necessary to have grant CREATE USER ON *.*. (ACCESS_DENIED)

批改配置后:

CREATE USER niewj IDENTIFIED WITH plaintext_password BY '246810' HOST ANY DEFAULT ROLE ALLQuery id: 065e8142-7e63-49d9-b69c-108a0d4ccfbdOk.0 rows in set. Elapsed: 0.001 sec.

3.2 dbeaver连贯clickhouse

批改配置: config.xml:放开此处正文

vim /etc/clickhouse-server/config.xml
211     <!-- Same for hosts without support for IPv6: -->212     <listen_host>0.0.0.0</listen_host>

4.端口凋谢

如果端口不凋谢当然拜访不了, 这里例举了凋谢80和443和8123, 只须要开8123就能够了!

4.1 开启端口80和443

如果你的服务器关上了防火墙，你须要运行上面的命令，关上80和443端口。

sudo firewall-cmd --permanent --zone=public --add-service=httpsudo firewall-cmd --permanent --zone=public --add-service=httpssudo firewall-cmd --reload

4.2 开启端口8123

# 1. 查问端口是否开启firewall-cmd --query-port=8123/tcp# 2. 开启端口8123firewall-cmd --zone=public --add-port=8123/tcp --permanent# 3. 使失效firewall-cmd --reload