Q1-Database Security:

Install MySQL Community Edition on your computer

1-Create a Create new user in EliteVideo database.

2-Define user roles and permissions to control access to the database

3-Test the access controls by logging in as different users and trying to perform various actions on the database.

Q2-Backup and Recovery:

You are requested to choose a backup technique for the business database.

In a short report, describe the following:

1-Full backup technique and how it works.

2-Illustrate through screenshots a Full backup to database EliteVideo

3-Advantages and disadvantages of full backup

4-Justify why full backup is suitable for the EliteVideo database.