use mysql;

-- 1. create a new database cs320stu31

create database cs320stu31;

-- 2. create a user cs320stu31, with password abcd, and grant the user
--    all privileges on the database cs320stu31. 

grant all privileges on cs320stu31.* to 'cs320stu31'@'localhost'
	identified by 'abcd' with grant option;

flush privileges;

-- 3. create a table items with two records.

use cs320stu31;

create table items (
	name		varchar(32),
	price		decimal(8,2),
	quantity	int
);

insert into items values ('milk', 3.89, 2);
insert into items values ('beer', 6.99, 1);