Tag Archives: Run under ‘sudo -u clickhouse‘

[Solved] ClickHouse Start Error: Run under ‘sudo -u clickhouse‘

Question:

Use command

clickhouse-server --config-file=/etc/clickhouse-server/config.xml

Start ClickHouse error:
Effective user of the process (root) does not match the owner of the data (clickhouse)
or
2022.01.13 00:32:46.999337 [ 3088 ] {} <Error> Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.

Solution:

Use the following commands:

# Satart ClickHouse
sudo systemctl start clickhouse-server

# Close ClickHouse
sudo systemctl stop clickhouse-server

# Check the status of ClickHouse
sudo systemctl status clickhouse-server