首页 > itarticle > influxdb command

influxdb command

admin 11月 13, 2020 0

Basic Command

Connect

influx -precision rfc3339


# rfc3339 tells InfluxDB to return timestamps in RFC3339 format (YYYY-MM-DDTHH:MM:SS.nnnnnnnnnZ)

Auth

Auth User
1

auth

Authenticate Telegraf requests to InfluxDB

## Write timeout (for the InfluxDB client), formatted as a string.
## If not provided, will default to 5s. 0s means no timeout (not recommended).
timeout = "5s"
username = "telegraf" #💥
password = "metricsmetricsmetricsmetrics" #💥

Create DB

1	CREATE DATABASE mydb

Drop DB

1	DROP DATABASE

Permission Management

Admin user management

CREATE USER
GRANT ALL PRIVILEGES
REVOKE ALL PRIVILEGES
SHOW USERS

Non-admin user management:

CREATE USER
GRANT [READ,WRITE,ALL]
REVOKE [READ,WRITE,ALL]
SHOW GRANTS

Case

# create admin user
CREATE USER <username> WITH PASSWORD '<password>' WITH ALL PRIVILEGES

# create normal user
CREATE USER <username> WITH PASSWORD '<password>'

1 2	# add database permission to user GRANT [READ,WRITE,ALL] ON <database_name> TO <username>

1	REVOKE ALL PRIVILEGES FROM <username>

1	SET PASSWORD FOR <username> = '<password>'

1	DROP USER <username>

Measurement

SHOW MEASUREMENTS

DELETE FROM MEASUREMENT

SELECT * FROM MEASUREMENT

Reference

https://blog.csdn.net/lancery988/article/details/50727026