1. clickhouse远程连接配置打开
首先进入root用户,编辑文件:
vim /etc/clickhouse-server/config.xml
打开注释:
<listen_host>::</listen_host>
然后重启click-house:
systemctl clickhouse-server restart
2. 防火墙配置
配置防火墙,打开8123端口:
sudo firewall-cmd --zone=public --add-port=8123/tcp --permanent
sudo systemctl restart firewalld.service # 重启防火墙