1. Open a Terminal window

1. and do the following:
   
   1. Navigate to the directory to which you downloaded the the attached CreateExamplegearDatabase_v1.sql file.

   2. Go into the mysql command line program as the root user by

1. 1. first command shown to the right.

   2. At the mysql prompt, execute the second command shown to the right to create the database and populate it with data.

Command to create the database

schema:

source CreateExamplegearDatabase_v1.sql

Verify the database creation was successful

1. Execute the commands shown to the right at the mysql prompt to ensure the schema and each of the tables were created successfully.
2. The output should look like the screenshot shown to the right.
3. At this point you should have the following:
   1. A MySQL database named examplegeardb running on port 3306 with a URL of localhost.
   2. A user account dbuser with a password of mypassword.
   3. These tables:
      • Addresses
      • Customers
      • Departments
      • Employees
      • LineItems
      • Products
      • Ref_AddressTypeCode
      • Ref_CountryCode
      • Ref_EmployeeStatusCode
      • Ref_OrderStatusCode
      • Sales

use examplegeardb;
show tables;

Output of the above commands:

Image Added

Create the Data Source Profile

To support running SQL queries against the examplegeardb database using the SQL for Confluence (Express Edition) add-on or SQL for Confluence (Pro Edition) add-on, you must build a data source profile.

1. While logged on to Confluence as a Confluence Administrator, type Manage add-ons in the Search box to go to the Manage Add-ons administration screen.
2. Scroll through the list of user-installed add-ons until you see the add-on named Bob Swift Atlassian Add-ons - SQL (Pro Edition) or Bob Swift Atlassian Add-ons - SQL (Express Edition).
3. Click the ">" icon to expand that entry.
4. Click Configure.
5. In the Data Source Profiles section, add a new entry with