ClickHouse Installation Guide
This guide provides all the key information and getting-started instructions after a successful ClickHouse installation via DeploySage-CLI. All content is consistent with the terminal output you saw during the installation process.
Installation Summary
Below is the core configuration information for your ClickHouse installation. The specific version number will vary based on the latest stable release at the time of installation.
| Item | Value |
|---|---|
| Installed Version | ClickHouse 22/23/24/25 |
| Service Name | clickhouse-server |
| Data Directory | /var/lib/clickhouse/ |
| Main Configuration File | /etc/clickhouse-server/config.xml |
| User Configuration File | /etc/clickhouse-server/users.xml |
Usage Guide
Service Management
Connecting to the Database
Common Commands
You can manage the ClickHouse service using standard systemctl commands:
Use clickhouse-client to connect to the database. By default, the default user has no password.
If a password is set, use:
Once inside the client, you can execute standard SQL commands:
# Start the service
sudo systemctl start clickhouse-server
# Stop the service
sudo systemctl stop clickhouse-server
# Restart the service
sudo systemctl restart clickhouse-server
# Check the service status
sudo systemctl status clickhouse-server
clickhouse-client
clickhouse-client --password
-- Show all databases
SHOW DATABASES;
-- Create a new database
CREATE DATABASE example;
-- Switch to a specific database
USE example;
-- Show all tables in the current database
SHOW TABLES;