Create a script that creates mysql databases and correct user permissions. Please any work in a sub-folder under the following participant_onboarding
Input:
Format of the input data is outlined in the data contract. If additional fields are needed please mention that.
Mysql:
Create databases for each team based on the schema of YYYY_team_9 (year_team_numberOfTeams)
Create a user for each team based on the schema of YYYY_team_9
Set the permissions on each user to only have full access to their respected database. For instance, user 2018_team_1 should only have full access to the database 2018_team_1.
Output:
Log the credentials for the username/password for each team to a file called output.json (txt is fine too).
Please see the CONTRIBUTING.md
Create a script that creates mysql databases and correct user permissions. Please any work in a sub-folder under the following participant_onboarding
Input:
Format of the input data is outlined in the data contract. If additional fields are needed please mention that.
Mysql:
YYYY_team_9
(year_team_numberOfTeams)YYYY_team_9
Output:
output.json
(txt is fine too).