Database Users

When creating a cluster, the user gen_user is automatically created. You can create new database users, grant them different rights to different databases, and generally manage them on the Users tab.

Creating users

To create a new user:

1. Go to the Database section and click on the cluster.

2. On the Users tab click Add.

3. Specify the parameters such as username, password and hosts.

4. Configure the privileges for this user (you can modify them later).

5. Click Create.

The Use the same privileges for all databases option is enabled by default. If necessary, you can turn it off and then select a specific database from the list to configure user privileges.

Configuring users

To change the privileges of an already created user:

1. Go to the Database section and click on the cluster.

2. Go to the Users tab.

3. Click on the three dots and select Privileges.

4. Set the privileges and save changes.

If the user privileges should be different for different databases, turn off the Use the same privileges for all databases option, and then configure the privileges by selecting the required databases from the list.

Changing user password

You can change the user password for connecting to the database on the Users tab.

1. Go to the Database section and click on the cluster.

2. In the Users tab click on the three dots for the desired user and select Change password.

3. Enter a new value and save changes.