Code: 210. DB::NetException: Connection refused (localhost:9000) 成功解决

• 1.clickhouse-server已成功启动，使用clickhouse-client连接clickhouse服务时报错 Code: 210. DB::NetException: Connection refused (localhost:9000)

systemctl status clickhouse-server
clickhouse-client --password

• 2.在网上查询解决方案：修改配置文件 /etc/clickhouse-server/config.xml，将listen_host改为::

#查询clickhouse-server的config.xml文件路径，默认在/etc/clickhouse-server/config.xml
find / -name config.xml
vim /etc/clickhouse-server/config.xml

• 3.重启clickhouse-server，连接clickhouse服务器。

systemctl stop clickhouse-server
systemctl start clickhouse-server
#查询clickhouse服务器状态
systemctl status clickhouse-server
clickhouse-client --password

• 4.补充：如果以上全部配置，datagrip等工具却无法连接clickhouse的话，可能是服务器防火墙的原因，需要开放8123端口

firewall-cmd --add-port=8123/tcp --permanent
#重启防火墙
systemctl restart firewalld.service
#查看所有已开放的端口
firewall-cmd --list-ports