Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: default: Not enough privilege

解决方式

 systemctl restart clickhouse-server #重启
 systemctl start clickhouse-server # 启动
 systemctl status clickhouse-server　＃查看状态

#创建用户并授权

CREATE USER clickhouse_admin IDENTIFIED WITH plaintext_password BY 'clickhouse_password'




授与新用户拥有所有管理权限

grant all on *.*  to  clickhouse_admin with grant option;