lwei_998的专栏

原创 DB::Exception: test: Authentication failed:

问题描述：想限制特定的IP可以访问clickhouse，使用如下语句创建用户 drop user test; CREATE USER test HOST IP '172.18.xxx.xxx' IDENTIFIED WITH sha256_password BY 'test'; GRANT SHOW, SELECT, INSERT ON test.* TO test; 客户端登陆： 确保输入的用户名和密码是正确的 clickhouse-client --host 172.18.xxx.xxx --po