进入本地的clickhouse sql编辑器:clickhouse-client
当我们需要远程连接clickhouse,需执行以下操作:
- 修改/etc/clickhouse-server路径下config.xml文件
<!-- Listen specified host. use :: (wildcard IPv6 address), if you want to accept connections both with IPv4 and IPv6 from everywhere. -->
<!-- <listen_host>::</listen_host> -->
<listen_host>::1</listen_host>
<listen_host>127.0.0.1</listen_host>
- 重启clickhouse
systemctl restart clickhouse-server