Configure a MySQL Database

Running head: CONFIGURE A MYSQL DATABASE
1
Assignment
Student
Course
Professor
Date

CONFIGURE A MYSQL DATABASE 2
Configure a MySQL Database
Database security refers to the measures that are taken to protect the database from
malicious usage. Security can be provided to the database at four levels, which includes a
database server, data stored in the database, DBMS (Database Management System), and work-
flow application (Glendon, 2011). The task of the assignment is to provide security to the
database named “classic models” for different users of the MySQL. Hence, the task at hand
involves creating the user and providing access to the classic model database for the particular
set of privileges with the help of grant command. Finally, determining how security is provided
to the database with access privileges.
Task
Creating Database User:
The database can be created with the following SQL statement:
Query:
CREATE USER 'jump'@'localhost' IDENTIFIED BY 'start';
Output:

CONFIGURE A MYSQL DATABASE 3
Loading Classicmodels Database:
The “classicmodels” database can be loaded with the help of the following command:
Query:
source C:\Users\Admin\Downloads\mysqlsampledatabase\mysqlsampledatabase.sql
Output:
Granting Privileges to the Classicmodels database
The SQL command to provide access to “classicmodels” database for creating, drop,
alter, insert, update, select, delete, and index privileges for the user are given below: