Influxdb

Influx

Influx

Initial Setup

Gui Admin

Influxdb Admin: http://localhost:8086

Command Line

• Organization List

influx org list --token R0xKoH7_r6w9lpkrTzQtwpeLCP82ZMfF3WDAftUtmFUpDgE0Wdq4GV1w6hozryht0h-gO4ypGn7TaE7V_frd-A=

• Bucket List

influx bucket list --token R0xKoH7_r6w9lpkrTzQtwpeLCP82ZMfF3WDAftUtmFUpDgE0Wdq4GV1w6hozryht0h-gO4ypGn7TaE7V_frd-A=

• User List

influx user list --token R0xKoH7_r6w9lpkrTzQtwpeLCP82ZMfF3WDAftUtmFUpDgE0Wdq4GV1w6hozryht0h-gO4ypGn7TaE7V_frd-A=

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