1. Home
  2. Support
  3. Databases
  4. Adding MySQL Users And Privileges

Adding MySQL Users And Privileges

Adding a new or existing user to an existing MySQL database:

  1. Navigate to Databases > MySQL > MySQL DBs.
  2. Select the database your wish to add a new user to.
  3. Select the Add button in the Database users section.
  4. Fill in the new user details and press the Add button.

Changing User Privileges

  1. Navigate to Databases > MySQL > MySQL DBs.
  2. Select the database that your user is assigned to.
  3. Click the first edit icon for the user you wish to change permissions for.


  4. Each user role involves a fixed set of privileges on this specific database:

    Role:

    Set of privileges:

    read

    select

    read/write

    select, insert, delete, update

    dba

    select, insert, update, drop, create, alter, index

  5. Select the relevant permissions you wish to apply to your user and press the Submit button.
Was this article helpful to you?

Last modified: 22/01/2018