clickhouse分片模式创建账号

环境:

OS:Centos 7

clickhouse:24.8.11.5

 

说明:

新版本可以在命令行模式下创建账号,同时赋予权限，不要在配置文件users.xml中指定账号了

只在一个节点上执行:

clickhouse-client -h 192.168.1.102 -m -u default --password clickhouse123 ##使用默认账号登录
create user hxl identified with plaintext_password by 'clickhouse123' on cluster default;
create database db_hxl on cluster default;
grant all on db_hxl.* to hxl on cluster default;

grant cluster on *.* to hxl on cluster default;
grant REMOTE ON *.* to hxl on cluster default;

注意都需要加上on cluster 分片名称，我这里的分片名称是使用默认的default(把分片配置放到default段落里实现)

 

创建只读账号

create user myreadonly identified with plaintext_password by 'clickhouse123' on cluster default;
grant select on db_hxl.* to myreadonly on cluster default;

 

删除账号

drop user hxl on cluster default;
drop user myreadonly on cluster default;