Creating a Connection in the Workbench

Software

1. MySQL Workbench 6.2

Outline

1. Create a new Schema
1. Open MySQL Workbench
1. logon as root
2. Create a new Schema
2. Create a User for the Schema
1. Grant Permissions
3. Create a Connection on the Workbench

Creating a new Schema

Open the workbench, and logon as root.

Create a new schema, and give it a name.

Accept the defaults when you hit Apply, and click Finish.

This will create a new schema in the Navigator view of the Workbench (the left hand pane):

Create a new User

Under the Navigator Management panel of the Workbench, click on Users and Privileges.

Click "Add Account" and give the user a name and password:

Next, we need to modify the administrative roles and schema privileges.

I click on "DBA" into administrative roles, and this gives me all the privileges I want:

Then click on schema privileges:

I've selected the schema I created earlier, and granted the user all privileges on this schema only.

Setup a new Connection in the Workbench

Within the Workbench, click on the + symbol to create a new connection:

Once inside, enter the required information:

and this will create a connection icon on the workbench: