Privileges empower users to alter and oversee databases. In Plesk, you can adjust or modify the MariaDB database user privileges.
Follow these steps:
-
Log in to your Plesk account.
-
Navigate to Databases in the menu to view all operational databases and associated options.
-
Click on User Management.
You'll see a roster of currently active database users.
-
Select the database user's name to modify its privileges.
Encounter a customizable user account form with settings.
Scroll down to find the Privileges section, categorized into Data Access and Structure Access.
-
Choose the desired privileges for the user and click the OK button at the bottom of the form.
This simple process concludes the granting of user privileges to a database in Plesk.