Bootstrapping the Database

A lot of functionality in Tradelib requires MySQL. This document provides the necessary details to setup the database for Tradelib.

MySQL Setup

Download the server from here and install it. Make sure the version is higher 5.6.4 (as of this writing the latest version is 5.6.26).

During this step, you will create a root account for the server.

MySQL Workbench is an useful addition if you prefer using an IDE to manage the server and the database.

Create the Database

Using the root account, create a database, either from the MySQL Workbench or from the command line utility (mysql). The defaults are fine: CREATE DATABASE quintuitive an alternative is: CREATE DATABASE quintuitive DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci.

Create and Populate Tables

The two scripts needed to accomplish this task are located in Tradelib\src\main\scripts\sql. They need to be edited before using them. The scripts use quintuitive as the database name. If you used a different name, then all references to quintuitive need to be changed.

The root account is used to create the database, but the scripts create another account (user qboss, password iddqd) which will be used by Tradelib. The scripts give qboss permissions to Tradelib's tables. To change the username and/or the password - simply edit the scripts.

Video Tutorial

Most of the steps are covered on this video.