> For the complete documentation index, see [llms.txt](https://docs.glesys.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.glesys.com/products/database/how-tos/manage-databases-and-users.md).

# Manage databases and users

***

## Managing databases and users using the control panel

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

<figure><img src="/files/nTtcW796y9SBCskvKJw2" alt=""><figcaption></figcaption></figure>

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**.

<figure><img src="/files/MRIsG8bntWVmeKQtZ6AU" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/L0b5AMrNvS2FcgxUNR65" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/jZ8MpBzDrHzYFsm2ty3A" alt=""><figcaption></figcaption></figure>

### Creating a new database

To create a new database, click **Create database**.

<figure><img src="/files/fNXzGoEec25NowL1sOvW" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/3Jbc01riUZo3U0n2QhTJ" alt=""><figcaption></figcaption></figure>

### Creating a new user

To create a new user, click **Create user**.

<figure><img src="/files/MJ7MulyRuuRlBFw6x2S8" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/8R4dzHUDDQMWhLfCxDwd" alt=""><figcaption></figcaption></figure>

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**.

<figure><img src="/files/gmI0LzHsPgiC3D9kOK7w" alt=""><figcaption></figcaption></figure>

### Assigning permissions

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

<figure><img src="/files/4T5tTqe0eSoqXqEBhCgR" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/srytLhN84uTYCjptzRSl" alt=""><figcaption></figcaption></figure>

### Deleting a database

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

<figure><img src="/files/OgKDNoeN5sua1I85SrTf" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/aM7aoMbzURvtKxhx6ibI" alt=""><figcaption></figcaption></figure>

### Deleting a user

To delete a user, click the three dots next to the user and select **Delete**.

<figure><img src="/files/P3B2sTmtbBmYQsuVp7yI" alt=""><figcaption></figcaption></figure>

To confirm the deletion, type the username in the field and click **Delete**.

<figure><img src="/files/FJB34b7fgECDY9IeIZfc" alt=""><figcaption></figcaption></figure>

## Managing databases and users using the API

Use the following API endpoints to manage databases and users:

* [database/createdatabase](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasecreatedatabase) to create a new database
* [database/deletedatabase](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasedeletedatabase) to delete a database
* [database/createuser](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasecreateuser) to create a new user
* [database/deleteuser](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasedeleteuser) to delete a user
* [database/resetuserpassword](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databaseresetuserpassword) to reset a user's password
* [database/setuserpermissions](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasesetuserpermissions) to assign permissions to a user
* [database/details](https://github.com/GleSYS/API-docs/wiki/API-Documentation#databasedetails) to list databases and users in an instance
