介绍
其实 influxdb 的权限语法和 MySQL 基本相似, 看完以后你基本就能了解;
授权语法
创建用户: CREATE USER <username> WITH PASSWORD '<password>'
授权权限: GRANT [READ,WRITE,ALL] ON <database_name> TO <username>
创建并授权: CREATE USER <username> WITH PASSWORD '<password>' WITH ALL PRIVILEGES
取消授权: REVOKE ALL PRIVILEGES FROM <username>
修改密码: SET PASSWORD FOR <username> = '<password>'
删除用户: DROP USER <username>
开启登录认证
- VIM /etc/influxdb/influxdb.conf
- [http]
- auth-enabled = true
- [root@localhost tmp]# influx
- Connected to http://localhost:8086 version 1.7.1
- InfluxDB shell version: 1.7.1
- Enter an InfluxQL query
- > show databases
- ERR: unable to parse authentication credentials
- Warning: It is possible this error is due to not setting a database.
- Please set a database with the command "use <database>".
- > auth
- username: monitor
- password:
- > show databases
- name: databases
- name
- ----
- _internal
- zabbix
- telegraf
- chronograf
- > 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
来源: http://www.bubuko.com/infodetail-2862597.html