How to create a Database User from SWPanel

1Create new DB user

To create a new database access user, you can do so by following these instructions:

First, access the dashboard of the service where you want to create the database user:

Then, go to Service Management and Database Management in the side blue menu.

Once here, select the DB Users tab and then click on Create new DB user.

Enter the new user's details and their password.

As we can see in the image, the new Database user has now been created successfully.

2Manage User permissions on the DB

If you want to define the permissions this user will have on the Database, go back to Database Management and this time select the MariaDB tab.

Locate the Database you wish to modify, click the three side dots, and select Modify MariaDB DB.

Here you will find the users created for the Database, and you can define the permissions for the DB.

There are three permission profiles: No control, Read, or Full Control.

1. No control: has no permissions, neither read nor write

2. Read: only has read permissions

3. Full Control: has full control, read and write permission

Once the permissions have been configured, you must save the changes for them to take effect by clicking on Save changes.