Adding MySQL Users And Privileges

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

1. 1. Navigate to Databases > MySQL > MySQL DBs.

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

1. 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. 1. Navigate to Databases > MySQL > MySQL DBs.

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

1. 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:

1. Select the relevant permissions you wish to apply to your user and press the Submit button.
   

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