Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL Server team/database creations #2

Open
crolek opened this issue Jan 28, 2018 · 0 comments
Open

MySQL Server team/database creations #2

crolek opened this issue Jan 28, 2018 · 0 comments
Labels
help wanted Extra attention is needed participant_onboarding

Comments

@crolek
Copy link
Contributor

crolek commented Jan 28, 2018

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:

  • 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).
@crolek crolek added help wanted Extra attention is needed participant_onboarding labels Jan 28, 2018
@crolek crolek changed the title MySQL Server team creations MySQL Server team/database creations Jan 28, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed participant_onboarding
Projects
None yet
Development

No branches or pull requests

1 participant