how to get databases list at influxdb in v0.8

Question

how to get all databases use http api from influxdb in v0.8?

but I can use this query in v0.9:

curl -G http://localhost:8086/query --data-urlencode "u=todd"  \
--data-urlencode "p=influxdb4ever" --data-urlencode "q=SHOW DATABASES"

I can't get any info on influxdb.com

thx

score 17 · Answer 1 · answered Apr 18 '17 at 13:00

17

I can get the database list using this statement: curl -G "http://somehost:8086/query?pretty=true" --data-urlencode "q=show databases" My InfluxDB version is 1.2.2

answered Apr 18 '17 at 13:00

Software Craftsman

2,999
2
31
47

As of 1.2. the admin interface is disabled by default. The HTTP API with curl is a better choice. – Andrei May 14 '17 at 16:17

score 4 · Answer 2 · edited Feb 24 '20 at 11:52

4

Using influxdb lib in python

install: $pip3 install influxdb

    from influxdb import InfluxDBClient

    client = InfluxDBClient(host='', port='', username='', password='')

    #return database in a list of dict
    dbs = client.get_list_database()

    #for better format
    list = []
    for db in dbs:
       list.append(db.get('name'))

edited Feb 24 '20 at 11:52

kvivek

3,321
1
15
17

answered Jul 15 '19 at 09:50

qloveshmily

1,017
9
5

`InfluxDBClient` object has no attribute `get_list_database` – benni Feb 14 '23 at 16:53

score 0 · Answer 3 · answered Dec 15 '15 at 23:36

0

Visit http://localhost:8083 on the host machine. The Admin UI has a list of the databases configured.

answered Dec 15 '15 at 23:36

beckettsean

1,826
11
7

As of 1.2. the admin interface is disabled by default. – Andrei May 14 '17 at 16:16
4

As of 1.4 the admin interface is no longer available and is replaced by Chronograf – PeeWee2201 Feb 21 '18 at 09:46

how to get databases list at influxdb in v0.8

3 Answers3