![cover](https://img-blog.csdnimg.cn/direct/65757e8b4a0f4771ba945807b385b140.png)
Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: default: Not enough privilege
【代码】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;
使用clickhouse_admin 用户创建一个列管理用户;
CREATE USER column_user IDENTIFIED WITH plaintext_password BY 'column_user'
创建一个行管理用户;
create user row_user identified with plaintext_password by 'row_user';
clickhouse 如何使用SQL 管理用户和角色_code: 497. db::exception: received from localhost:_行走在云端z的博客-CSDN博客
更多推荐
所有评论(0)