MariaDB. Managing database access

A MariaDB user can be granted access to one or several databases on the server. Access is always full — BeAdmin does not split privileges by operation (SELECT, INSERT, etc.): once granted, the user works with the database as a whole.

You can do this in two ways: pick the databases right when creating a new user, or grant access to an existing user.

Create a user with database access

If the user does not exist yet, create them and pick the databases at the same time — no separate step to grant access is needed.

1. Open the MariaDB module, switch to the "Users" tab, and click "Create user".
2. In the "Create user" dialog, fill in the fields:
   • "Name" — use Latin letters, numbers, and underscores.
   • "Password" — at least 8 characters, including letters, numbers, and symbols; type your own or, if you don't want to come up with one, click the generator button next to the field — a password will be created automatically.
   • "Databases" — a multi-select dropdown: pick one or more databases the user will have access to. If the database you need does not exist yet, create it with the button to the right of the field — it will be selected immediately after creation.
3. Click "Create".

The user will appear on the "Users" tab with the selected databases — no extra step to grant access is required.

Grant access to an existing user

1. On the "Users" tab, find the row you need and click the icon on the right with the "Grant database access" tooltip.
2. In the dialog that opens, select one or more databases. The list shows only databases the user does not yet have access to.
3. Click "Save".

The selected databases will appear in the user's access list.

If the list has no databases, one of two messages will be shown in the select field:

• "Access granted to all" — the user already has access to every database on the server.
• "The database list is empty" — there are no databases on the server yet. Create one with the same button to the right of the field — it will appear in the list once created.

Revoke access

Revoking only removes access — the databases and their data stay on the server.

1. In the user's row, click the icon on the right with the "Revoke database access" tooltip.
2. In the dialog that opens, select one or more databases. The list shows only databases the user currently has access to.
3. Click "Revoke".

The selected databases will disappear from the user's access list.

If the user no longer has access to any database, the select field will show "All access revoked" — there is nothing left to revoke.

See also

• Deploy a website with PHP, Nginx, and MySQL using BeAdmin