我在Windows主机上的Docker容器中运行Clickhouse。 我尝试创建一个管理员账户,但是默认用户似乎没有权限创建其他账户。 如何解决此错误并创建管理员账户?
docker-compose exec -T dash-clickhouse clickhouse-client --query="CREATE USER 'foo' IDENTIFIED WITH sha256_password BY 'bar'"
出现了错误
Received exception from server (version 20.7.2):
Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: default: Not enough privileges. To execute this query it's necessary to have the grant CREATE USER ON *.*.