CSC220 Lab 5 MySQL

Creating the Databases

• This is just for completeness and does not have to be performed.

• for all accounts from aa to ao, run the query

CREATE DATABASE `220a-ac`CHARACTER SET utf8 COLLATE utf8_general_ci;

• Similarly, create users with same name