Option #2: Configure a MySQL Database
Download the "classicmodels" database from the following MySQL website: Create a database user named "jump" with password "start". Load the "classicmodels" database into your MySQL database instance. Grant "create", "drop", "alter", "insert", "update", "select", "delete", and "index" privileges for user "jump" on the "classicmodels" database. Submit a 2- to 3-page Microsoft Word document containing a screen shot of the tables in the "classicmodels" database. Provide brief explanation of the MySQL grant command. How is this command used to implement database security?
Document information
- Uploaded on
- February 16, 2022
- Number of pages
- 6
- Written in
- 2021/2022
- Type
- Exam (elaborations)
- Contains
- Questions & answers