Creating a user

Before you can connect, write data or query a database, you will need to create database users and set the privileges of each database user appropriately.


Click on the Users and Privileges tab to view the users list, then click on the + NEW button. A window will appear as shown below.


The names of all databases users will be in the form of {username}_{database_username}. You will only need to fill in the database username as suggested in the Users and Privileges window.

You can either enter your own database user password or click the Generate button to generate a random password. Either way, be sure to memorize or record the password so you can enter it later. Once the new database user is created and form is submitted, the password will not be shown again; it is hashed by the service. If you forget, you will need to generate a new password.

Next, you need to set the privileges of the database user. Click on the Add New Privilege button to do this. Using the available options, you can set the database user priveledges to one of the following:

For example, lets create a database user for one of our flows that writes sensor data to a database. To do so, we will create a user that has “write only” privilege to “testrobot1_testdb”. This database user will only be allowed to write data to the “testrobot1_testdb” database, and will never query data.


Once you click submit, you will see the new user appear on the user list with the privileges details shown:


Next, lets create a database user for another flow that is used only for querying (reading) data from the database:


You can now connect to the STS-InfluxDB from FRED as described next.

Connect with FRED »