Create a database setup script

[edwardUL99]

This script should enable a database user with privileges to create a database and database users to quickly setup the database by also importing all the required sql files.

This should:

• Not have any hard coded passwords and host names (i.e. have the script ask the user for them)
• Passwords should have echo turned off (i.e. do not display on terminal)
• Check if the database exists (if possible, if not just assume the user knows it doesn't exist already). If possible and it already exists, throw an error)
• Create the database with a specified database name
• Create a user with specified username and password
• Grant all privileges to that user on the database you created
• Import all sql tables

[edwardUL99]

See https://stackoverflow.com/questions/47645383/create-table-works-in-mysql-but-not-in-bash

[edwardUL99]

And https://stackoverflow.com/questions/7364709/check-if-mysql-database-exists-perform-action-based-on-result

[edwardUL99]

Example command mysql "student_sys" -u studsys -p -e exit -h pi > /dev/null 2>&1 && echo "Database exists"