INFLUXDB Basic Operation

Entering the CLI interface Influxdb Shell (CLI)

/opt/influxdb/influx

Database

Show all Databases show DATABASES

Adding databases CREATE database MyDB

Deleting a database Drop DB mydb

User

Show all user Show Users

Creating user Create users Leo with PASSWORD ' admin '

Modify User (password) SET PASSWORD for Leo = ' admin '

Delete users drop user Leo

Data retention Period

View retention period show RETENTION policies on MyDB

Modify the retention period ALTER RETENTION POLICY default on MyDB DURATION 2d

Delete retention period Drop RETENTION POLICY <retentionpolicy> on <database>

Database access Permissions

Create Permissions GRANT READ on MyDB to Leo

Revoke permissions REVOKE all on MyDB from Leo administrative permissions

Create cluster administrative permissions GRANT all privileges to Leo

Revoke cluster administrative permissions REVOKE all privileges from Leo

Identity verification

Identity authentication by default, identity authentication is turned off. In other words, you can access the database without using your account and password. You need to use a configuration file to configure

Configuration file

The default configuration file is persisted:/etc/opt/influxdb/influxdb.conf

To restart after modifying the configuration

Restart

/etc/init.d/influxdb restart

Resources

Https://influxdb.com/docs/v0.9/administration/administration.html

INFLUXDB Basic Operation