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