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?
Escuela, estudio y materia
- Institución
-
Colorado State University
- Grado
-
ITS 410 (ITS)
Información del documento
- Subido en
- 16 de febrero de 2022
- Número de páginas
- 6
- Escrito en
- 2021/2022
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
- its 410
-
create a database user named jump with password start load the classicmodels database into your mysql database instance grant create
-
drop
-
alter
Documento también disponible en un lote