Clickhouse installation and remote login on

Time:2021-10-20

1、 Installation of Clickhouse

1. Add Yum source

 yum-config-manager --add-repo http://repo.red-soft.biz/repos/clickhouse/repo/clickhouse-el6.repo 

2. Installation

 yum install clickhouse-server clickhouse-client clickhouse-server-common clickhouse-compressor 

3. Start service

 /etc/init.d/clickhouse-server start 

4. Login test

[[email protected]_server_yayun_01 ~]# clickhouse-client 
ClickHouse client version 20.5.2.7 (official build).
Connecting to 127.0.0.1:9000 as user default.
Connected to ClickHouse server version 20.5.2 revision 54435.
VM_0_15_centos :) 
VM_0_15_centos :) 
VM_0_15_centos :) 
VM_0_15_centos :) 

2、 Clickhouse remote login

1. Modify profile

[[email protected]_server_yayun_01 ~]vi /etc/clickhouse-server/config.xml 

< listen found_ host>::</listen_ Host > remove commentsClickhouse installation and remote login on

3、 Client connection (dbaver)

1. Host: the IP address of the Clickhouse remote login server

2. User name and password: default; password is blank

3. Dbeaver has a community version. Because it is a client, it will be more convenient and easy to use than tabix

Clickhouse installation and remote login on Clickhouse installation and remote login on