- Browse to https://mariadb.com/downloads, where you can download the version applicable to your software.
- Install the default settings.
- The important settings are MariaDB should be configured by default to 3306. One Global access account should exist.
- Open Heidi the SQL client that comes with MariaDB (Windows).
- Connect to the database, use root user unless you created an account already:
- Save the file foodbook.sql to your computer. It is in the main directory of this repository as foodbook.sql.
- Go to the file menu select load SQL File:
- Hit the blue play button:
- You will probably see some errors, this is normal and is syntactical, the file was auto-generated.
- Accept the errors and click on the pane on the left, hit refresh. Foodbook will appear in the left pane.
- Click on the little people to create an account:
- Create the account as dbreadonly, accept connections from everywhere ‘%’, leave password blank, and grant SELECT.
- Import the foodbooksqldb repository into intellij or clone it
- Open a cmd prompt (or hit play in intelliJ, your preference) Browse to the root project folder usually ~\IdeaProjects\FoodBookSQLDB, but will be different if you clone and type ‘grails run-app’.
- Open your web browser and type localhost:8080/
- You should see our fledgling prototype.
There are only three unique ingredients, 'Love', 'seasoning', and 'chicken', the recipe names are all star chicken. So example one star chicken.
You can test out this functionality.