Influxdb

Influx

Influx

Initial Setup

Force listen on local IP

[http]
  bind-address = ."192.168.1.10"

Connect to a specific host

influx -host  myInfluxHost

Create Admin User

influx

CREATE USER myAdmin WITH PASSWORD 'myPassword' WITH ALL PRIVILEGES

Enable Authenticatification

[http]
   auth-enabled = true

Use Database

Connect

• Authentification

auth
   username:
   password:

Create Database

CREATE DATABASE database_name
CREATE RETENTION POLICY "two_days" ON "myDatabase" DURATION 2d REPLICATION 1
SHOW DATABASES

Manage Users

Create user

CREATE USER myAdmin WITH PASSWORD 'myPassword'

Change Passsword

SET PASSWORD FOR myUser = 'myPassword'

Show users

SHOW USERS

Manage Acces Rights

Grant user to Database

GRANT All ON "myDatabase" TO "myUser"

• Use Database

use myDatabase