Legacy


  1. Home
  2. Legacy
  3. Databases
  4. Adding MySQL Users And Privileges
Click here for full details

Adding MySQL Users And Privileges

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

    1. Navigate to Databases > MySQL > MySQL DBs.

    1. Select the database your wish to add a new user to.

    1. Select the Add button in the Database users section.

  1. Fill in the new user details and press the Add button.

Changing User Privileges

    1. Navigate to Databases > MySQL > MySQL DBs.

    1. Select the database that your user is assigned to.

    1. Click the first edit icon for the user you wish to change permissions for.

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

  1. Select the relevant permissions you wish to apply to your user and press the Submit button.
Click here for full details

Classification: Public
Last saved: 2021/11/11 at 14:30 by Jamie

How can we help?