Setting up a development database

These changes are tagged in the GitHub repo as CH-13-Database-set-up

As HMS engineers already know that the production service’s database will be MySQL, they will install a local MySQL instance to develop against, and since the setup of a development database is generally going to be a one-time exercise, they decide to simply document the steps that are needed to accomplish it, capturing what they can in some .sql scripts (in the hms-core/database/HMS/set-up directory in the chapter repository):

• Installation of MySQL.
• Creation of a local development database (named HMS_DEV for everyone): 001-create-application-database.sql
• Creation of a database account that the service will use to access data (hms-service-user): 002-create-application-user.sql
• Granting basic permissions, for INSERT, SELECT, UPDATE, and DELETE SQL operations, to all tables and views, and EXECUTE for any functions or procedures in...