This project uses Express 4 for routing and Flex.Query Processor Library 2 for querying MySQL database.
NodeJS, MySQL Server and MySQL Workbench are required.
NodeJS
- Install NodeJS
MySQL Server
-
Download MySQL Installer Community 8.x
-
Select MySQL Server 8.0 to install
-
Follow on-screen instructions to install and proceed with default settings (enter your choice of root password for your MySQL instances when prompted in one of the screens)
-
Update your root user password in dbConfig.json
MySQL Workbench
-
Install MySQL Workbench 8.x CE
-
Double-click "Local instance MySQL80"
-
Go to "Server" Menu > "Data Import" > "Import from self-Contained File" > Open autoauth table schema
-
Run the following command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOURPASSWORDHERE'
Run npm start
to start the server, listening on port 4300
Main code logic lies here.