Project Assignment 6

There's just a little bit more of the tutorial that is important to cover, especially regarding AUTO_INCREMENT.

In addition, we're going to create a specific user and database for our application.

Specific Tasks

First, follow the tutorial pages linked below (also provided in class). Please ignore:

• The first two paragraphs of 3.6
• All of 3.6.4
• Stuff above 3.6.9 on page 189.

Before we create our project database, it's always best to use a non-root user. Create a new MySQL user called music_app for this purpose.(Documentation)

-> GRANT select,insert,update,delete,create,drop,alter
   ON *.* to music_app@localhost
   IDENTIFIED BY 'password';
-> FLUSH PRIVILEGES;

Now lets just create our first database, for the music client application. (Documentation)

-> CREATE DATABASE music_client;

Document the username, host, and permissions granted. Also document the name of the music client app database.

PDF of Tutorial here -- a hard copy will be provided in class.

NOTE: Documentation created to date must be handed in Wednesday, Jan 23 by 5PM for review.