02-influxdb的权限管理

• 01-InfluxDB介绍请添加链接描述

• 02-influxdb的权限管理

• 03-Influxdb的备份与恢复

介绍

其实influxdb的权限语法和mysql基本相似，看完以后你基本就能了解；

授权语法

1. 创建用户：CREATE USER WITH PASSWORD ''
2. 授权权限：GRANT [READ,WRITE,ALL] ON TO
3. 创建并授权：CREATE USER WITH PASSWORD '' WITH ALL PRIVILEGES
4. 取消授权：REVOKE ALL PRIVILEGES FROM
5. 修改密码：SET PASSWORD FOR = ''
6. 删除用户：DROP USER

开启登录认证
vim /etc/influxdb/influxdb.conf

[http]auth-enabled = true

[root@localhost tmp]# influx

Connected to http://localhost:8086 version 1.7.1InfluxDB shell version: 1.7.1Enter an InfluxQL query> show databasesERR: unable to parse authentication credentialsWarning: It is possible this error is due to not setting a database.Please set a database with the command "use ".> authusername: monitorpassword:> show databasesname: databasesname----_internalzabbixtelegrafchronograf> quit

授权操作

1.创建超级用户
创建用户：monitor
密码：zabbix
权限：全部权限（超级用户）
create user monitor with password 'zabbix' with all privileges

2.创建只读用户
用户：monitor_ro
数据库：monitordb
权限：指定数据库的只读权限

create user monitor_ro with password 'zabbix_apipwd'
grant read on monitordb to monitor_ro

3.创建可以写用户
用户：monitor_rw
数据库：monitordb
权限：指定数据库的写权限

create user monitor_rw with password 'zabbix_apipwd'
grant write on monitordb to monitor_rw

4.取消用户授权
取消用户授权：

REVOKE ALL PRIVILEGES FROM monitor_rw

5.查看所有用户

SHOW USERS
user admin

---

monitor true
monitor_ro false
monitor_rw false

6.删除用户

DROP USER monitor_rw