In this article, I explain how we can modify MySQL/MariaDB database user privileges in the Plesk Panel.
Step 1: Log in to your Plesk Control Panel.
Step 2: Click on the Databases Icon under the Websites and Domains module
Step 3: Click on the User Management
Step 4: Click on the database user's name to modify its privileges
Step 5: Scroll down the page to the Privileges section, which is categorized into Data Access and Structure Access.
Here, you'll find a list of privileges assigned to the user.
To modify these privileges, just check or uncheck the boxes next to the corresponding checkboxes to grant or remove access as required.
Step 6: Select the user's desired privileges and click the OK button at the bottom of the page.
That way, we can modify the database user privileges in the Plesk panel.