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?
Geschreven voor
- Instelling
- Colorado State University
- Vak
- ITS 410 (ITS)
Documentinformatie
- Geüpload op
- 16 februari 2022
- Aantal pagina's
- 6
- Geschreven in
- 2021/2022
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
its 410
-
create a database user named jump with password start load the classicmodels database into your mysql database instance grant create
-
drop
-
alter
Ook beschikbaar in voordeelbundel