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?
Written for
- Institution
-
Colorado State University
- Module
-
ITS 410 (ITS)
Document information
- Uploaded on
- February 16, 2022
- Number of pages
- 6
- Written in
- 2021/2022
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- its 410
-
create a database user named jump with password start load the classicmodels database into your mysql database instance grant create
-
drop
-
alter
Also available in package deal