Manage databases and users

You can add more than one database in each database instance. You can also create users and assign each user either read or read/write access to the databases in a database instance.

Managing databases and users using the control panel

To view and manage the instance's databases and users, click the Databases and users tab.

The default database is defaultdb, and the default user is dbadmin. These can't be removed. The password for dbadmin can, however, be reset.

The user dbadmin will always have read & write access to all databases.

To reset the dbadmin password, click the three dots next to the user, then click Reset password.

A dialog box will open, telling you that a new password will be generated for dbadmin. To confirm, click Reset password.

Please note that any changes you make, such as resetting a password, assigning permissions, or creating users, will take a while before they are applied to the database backend. At the top of the page, you'll see the status as Updating... while the changes are being applied.

Creating a new database

To create a new database, click Create database.

Give the new database a name, and click Create database.

Creating a new user

To create a new user, click Create user.

Give the new user a name, and click Create user.

A dialog box with the user's password will open. Copy the password and save it in a secure place. It will not be shown again. Once you have copied the password, click Got it.

Assigning permissions

To assign a user permission to a database, click the three dots next to the user and click Edit permissions.

Next, select which permissions the user shall be given for each database. In this example, the user is given read & write permissions for my_own_db, and only read permissions for defaultdb. Click Save to save the changes.

Deleting a database

To delete a database from the instance, click the three dots next to the database and select Delete.

To confirm the deletion, type the database name in the field and click Delete. Note that this will permanently delete the database and all data stored in it.