use mysql;

-- 1. create a local user cs3220stu31 with password abcd

create user 'cs3220stu31'@'localhost' identified by 'abcd';
 
-- 2. create a database cs3220stu31

create database cs3220stu31;

-- 3. grant all privileges on the database cs3220stu31 to the user cs3220stu31

grant all privileges on cs3220stu31.* to 'cs3220stu31'@'localhost' with grant option;

flush privileges;

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

use cs3220stu31;

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);