Create User and Assign Permissions

This page describes adding a mysql user and assigning permissions for that user to access a database. It is advisable to have non-root (i.e., non-administrator) user accounts for accessing the database.

1) Start MySQL Workbench, select "Users and Permissions," click "Add Account," select a username (e.g., "datauser"), enter the password twice, and click "Apply."

2) Select the user (selected by default if just added), open the tab "Schema Privileges," click "Add Entry."

3) Choose the option "Select schema," select the schema, click "OK."

4) Click "Select "ALL"," click "Apply."