Influxdb

From Objectif Client Inc
Jump to navigation Jump to search

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

Create user

CREATE USER myAdmin WITH PASSWORD 'myPassword'

Show users

SHOW USERS

Grant user to Database

GRANT All ON "myDatabase" TO "myUser"
  • Use Database
use myDatabase