Top39：Centos 安装部署clickhouse数据库-Linux配置ClickHouse数据库

卸载
查看安装情况

yum list installed | grep clickhouse

卸载

yum remove -y clickhouse-common-static clickhouse-common-static.x86_64 clickhouse-server-common
rm -rf /var/lib/clickhouse
rm -rf /etc/clickhouse-*
rm -rf /var/log/clickhouse-server

1、安装 clickhouse

yum install yum-utils -y
rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo -y
yum install clickhouse-server clickhouse-client -y

如果不行就需要下载仓库：

curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo os=centos dist=7 bash

启动服务端

systemctl start clickhouse-server

进入客户端

clickhouse-client

输入命令测试，能进入就继续配置

show databases;

2、配置用户密码

打开用户配置文件

vim /etc/clickhouse-server/users.xml

找到标签

注释默认空账号，输入下面信息，保存退出

<用户名>
	<password>密码</password>
		<networks incl="networks" replace="replace">
			<ip>::/0</ip>
		</networks>
		<profile>default</profile>
		<quota>default</quota>
</用户名>

测试新账号密码登录

clickhouse-client  --user 用户名 --password 密码
clickhouse-client --user root --password yourpassword

测试默认登录，不能成功

clickhouse-client

3、指定ip、端口

找到配置文件的路径

vim /etc/clickhouse-server/config.xml

<listen_host>::</listen_host> 

修改端口号

软件连接对应的端口

<http_port>8602</http_port>

代码连接对应的端口

<tcp_port>8601</tcp_port>

重启服务

systemctl restart clickhouse-server

防火墙开启端口号

firewall-cmd --add-port=8603/tcp --permanent
firewall-cmd --query-port=8603/tcp

重启防火墙

firewall-cmd --reload

查看防火墙开启的端口号

firewall-cmd --list-port

指定ip端口测试

clickhouse-client --user root --password yourpassword --port yourport --host ip