'ClickHouse connection refused after shut down Linux OS (error Code: 210. DB::NetException: Connection refused)

I saw a previous post on StackOverflow related to my question. I tried to handle this connection problem by entering sudo nano /etc/clickhouse-server/config.xml Then, put <listen_host>::</listen_host> enabled in that config file, but the problem still exists. Yesterday I connected to ClickHouse server normally. But after shut down Linux OS (runs on VMWare), today I turn on again and got this connection refused problem. All solutions I searched on the internet couldn't solve this issue. Please tell me how to solve it. Below is the screenshot of the commands I used:

enter image description here

linuxdatabaseolapclickhouse


Solution 1:[1]

I had exactly the same problem after I did:

sudo service clickhouse-server restart

and cancelled action during restart. This simple command solved the issue:

sudo clickhouse start

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 vitaliis

Related Questions