设置ClickHouse默认用户default的密码

墨蓝 2022-12-06 01:12 1714阅读 0赞

### 1、明文密码 ###

（1）查找user.xml文件

[root@elastic1 app]# cd /etc/clickhouse-server/
    [root@elastic1 clickhouse-server]# ll
    total 40
    drwxr-xr-x 2 root root  4096 Sep 11 13:39 config.d
    -rw-r--r-- 1 root root 22601 Sep 11 13:45 config.xml
    lrwxrwxrwx 1 root root    41 Sep 11 13:39 preprocessed -> /var/lib/clickhouse//preprocessed_configs
    drwxr-xr-x 2 root root  4096 Sep 11 13:39 users.d
    -rw-r--r-- 1 root root  5190 May 19 00:26 users.xml
    [root@elastic1 clickhouse-server]# vi users.xml

（2）修改密码

<users>
            
            <default>
                
                <password>123456</password>

（3）重启服务

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

### 2、SHA256密码 ###

（1）SHA256加密  
例如对密码`123456`进行SHA256加密

[root@elastic1 clickhouse-server]# echo -n 123456 | openssl dgst -sha256
    (stdin)= 8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92
    [root@elastic1 clickhouse-server]#

（2）修改default用户密码

（3）重启服务，密码登录

[root@client app]# systemctl restart clickhouse-server

[root@client ~]# 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.
    
    client :) show databases;
    
    SHOW DATABASES
    
    ┌─name────┐
    │ default │
    │ system  │
    └─────────┘
    
    2 rows in set. Elapsed: 0.002 sec.
    
    client :)