gpg

/usr/share/keyrings/clickhouse-keyring.gpg

--keyserver

/usr/share/keyrings/clickhouse-keyring.gpg

apt

[signed-by/usr/share/keyrings/clickhouse-keyring.gpg]

https://packages.clickhouse.com/deb

stable

/etc/apt/sources.list.d/clickhouse.list

更新软件包

https://packages.clickhouse.com/rpm/clickhouse.repo

sudo

/etc/clickhouse-server/config.xml

tmp_path/var/lib/clickhouse/tmp//tmp_path,

user_files_path/var/lib/clickhouse/user_files//user_files_path

日志路径

/etc/clickhouse-server/config.xml

sudo

/etc/clickhouse-server/config.xml

sudo

/etc/clickhouse-server/config.xml取消注释,

同时服务IPv6和IPv4

listen_host::/listen_host如果只需要提供IPv4,

listen_host0.0.0.0/listen_host这两行不能同时取消注释,

启动会报错

/etc/clickhouse-server/user.xml

配置用户口令

/etc/clickhouse-server/user.xml

默认用户

明文口令直接用passwordqwerty/password进行设置SHA256口令用password_sha256_hex65e84be33532fb784c48129675f9eff3a682b27168c0ea744b2cf58ee02337c5/password_sha256_hexDouble

SHA1口令用password_double_sha1_hexe395796d6546b1b65db9d665cd43f0e858dd4303/password_double_sha1_hexLDAP验证用ldapservermy_ldap_server/server/ldapKerberos验证用kerberosrealmEXAMPLE.COM/realm/kerberos

SHA256

e17cd697e0845d75d2068ae1e1479d3fd10d76e5afa89724fbc6fe27554526e4

SHA256结果#

e9fdf3480016dfae8ad0170e846edd031180a3f4

Double

e08ebd515246f1b5f3bfdb24b967a797b7218289b263ed0fbb3ff47fcc121f1b如果需要自定义

PASSWORDasdf1234;

dda7b4594264195da8bb303516d7ec5509b7b942

user.d

clickhouseusersdbownerpasswordabcd1234/passwordnetworksip::/0/ip/networksprofiledefault/profilequotadefault/quotaaccess_management1/access_management/dbowner/users

/clickhouse上面这个配置

https://clickhouse.com/docs/en/operations/access-rights

dbowner

access_management1/access_management

named_collection_control1/named_collection_control

show_named_collections1/show_named_collections

show_named_collections_secrets1/show_named_collections_secrets在安装

ClickHouse

21AC41BC256B35A32EC2021D359AE5F297AD7ED2F8ED8F7A2A1A7B9F1F94F898

SALT

56DC39142C0AEB19BC2C61AACBD9F27DD040E25489CC29B76D07D65F6D2A3AA1

Query

d0099db9-b292-4905-84bd-a91da19f8edc

Ok.

92a50da8-d847-4f4f-a74c-95b9f1207a67

rows

named_collection_control1/named_collection_control

show_named_collections1/show_named_collections

show_named_collections_secrets1/show_named_collections_secrets重启

ClickHouse

f4eaa3ce-8182-4717-9270-ce2e95eb2b88

Ok.

my_user;可以看下只开了access_management的

default

dbroot────────────────────────────┐

GRANT

└──────────────────────────────────────────────┘:)

show

default─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐

GRANT

└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘取消权限

REVOKE

https://jishuin.proginn.com/p/763bfbd59c4bhttps://zhuanlan.zhihu.com/p/421469439https://www.tinybird.co/blog-posts/text-search-at-scale-with-clickhousehttps://clickhouse.com/blog/clickhouse-search-with-inverted-indices