Environment Setup

Linking Intellij to mysql

1. Install mysql
2. Create mysql account, grant this account all privileges
3. Go and click 'View' at the top, make sure 'Tool Buttons' is checked
4. Click 'Database' at the right-most tool bar
5. Download the required drivers for mysql
6. Click the '+' button to create new 'Data Source' -> 'MySQL'
7. At the Database tab, input the user name and password. Click 'Test Connection' to make sure successful connection.
8. Click 'Apply' and 'OK'

Finally, right click the 'reset.sql' script in src/database_scripts/, from the pop-up set the data source dialog to be 'mysql' and click run.