This guide explains how to modify database user privileges in DirectAdmin's MySQL Management interface. Adjusting privileges allows you to control what actions a database user can perform, such as reading, writing, or modifying database structures.

How to Modify Database User Privileges

  1. Step 1: Access MySQL Management

    Log in to your DirectAdmin account. In the Account Manager section, select the MySQL Management icon or enter "MySQL Management" in the Navigation Filter box to reveal the option. Click on it to proceed.

    MySQL Management in DirectAdmin

  2. Step 2: Select the Database

    Navigate to the "Database" section and select the database for which you want to adjust privileges.

    Database selection

  3. Step 3: Open Privilege Modification

    In the "User List" section, locate your database users. Click on Modify Privileges to make adjustments.

    Modify Privileges button

  4. Step 4: Adjust and Save Privileges

    Adjust privileges as per your requirements, then click the Change button.

    Privilege adjustment interface

    The modifications to your database user privileges have been applied successfully.