influxdb

influxdb

客户端登录

infux -port 18086 -host 127.0.0.1

查看有哪些数据库

show databases

使用数据库

use prometheus

查看表结构

show tag keys from prometheus_1

表查询

seletct * from from prometheus_1

seletct * from from prometheus_1 order by time

seletct * from from prometheus_1 order by time limit 2

创建用户并授权

#添加一个管理员用户
create user "root" with password 'root' with all privileges

create user "root" with password 'root'
grant write on "prometheus" to "root"

查看用户授权信息

show grants for root