ClickHouse：新建数据库实例

曾经终败给现在 2022-12-06 15:48 179阅读 0赞

1、创建数据库实例

[root@elastic1 ~]# clickhouse-client --query "CREATE DATABASE IF NOT EXISTS tutorial"
    Code: 210. DB::NetException: Connection refused (localhost:9000)
    
    [root@elastic1 ~]#

发现不能本地登录，修改配置文件

[root@elastic1 ~]# vi /etc/clickhouse-server/config.xml 
    
        
        
        <listen_host>0.0.0.0</listen_host>
    
        
        <listen_host>::1</listen_host>

修改配置文件后，重启服务

[root@elastic1 ~]# systemctl restart clickhouse-server

2、录入密码

[root@elastic1 ~]# clickhouse-client --query "CREATE DATABASE IF NOT EXISTS tutorial"
    Code: 516. DB::Exception: Received from localhost:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. 
    
    [root@elastic1 ~]#

[root@elastic1 ~]# clickhouse-client --password --query "CREATE DATABASE IF NOT EXISTS tutorial"
    Password for user (default): 
    [root@elastic1 ~]#

3、查看新建的数据库

[root@elastic1 ~]# clickhouse-client --password
    ClickHouse client version 20.3.9.70 (official build).
    Password for user (default): 
    Connecting to localhost:9000 as user default.
    Connected to ClickHouse server version 20.3.9 revision 54433.
    
    elastic1 :) show databases;
    
    SHOW DATABASES
    
    ┌─name─────┐
    │ default  │
    │ system   │
    │ tutorial │
    └──────────┘
    
    3 rows in set. Elapsed: 0.003 sec. 
    
    elastic1 :)

![在这里插入图片描述][20200914111353526.png_pic_center]

[20200914111353526.png_pic_center]: /images/20221123/715a1a033c0d453db6a119e15b424273.png