Code: 210. DB::NetException: Connection refused (localhost:9000)

Clickhouse本地服务器执行连接的时候提示Code: 210. DB::NetException: Connection refused (localhost:9000)

解决方法:

1.首先检查监听网段<listen_host>::</listen_host>
2.检查配置服务端口信息

目前我们的服务监听已经在0.0.0.0

root@iZ2zeipez8ut08dv6ypru0Z:~# lsof -i:9000
COMMAND     PID       USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
clickhous 23544 clickhouse   29u  IPv4 101164      0t0  TCP *:9000 (LISTEN)
root@iZ2zeipez8ut08dv6ypru0Z:~# 
root@iZ2zeipez8ut08dv6ypru0Z:~# netstat -lntup|grep 9000
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN      23544/clickhouse-se 

这里只要使用--host不走localhost就可以解决

root@iZ2zeipez8ut08dv6ypru0Z:~# clickhouse-client --host=127.0.0.1 --password
ClickHouse client version 21.3.19.1 (official build).
Password for user (default): 
Connecting to 127.0.0.1:9000 as user default.
Connected to ClickHouse server version 21.3.19 revision 54447.

iZ2zeipez8ut08dv6ypru0Z :) show databases;

SHOW DATABASES

Query id: 573824f8-246a-4a7c-acb6-f3b3e2bb22b8

┌─name────┐
│ default │
│ system  │
└─────────┘

2 rows in set. Elapsed: 0.002 sec.