To list all the users
select user from mysql.user;


show grants for test@localhost;


grant all privileges on `test%`.* to test@localhost;	// note that it is the back tick around `test%`
							// can create any database with name starting with test
grant all privileges on test.* to test@localhost;	// can only create a database named test

revoke all privileges on *.* from test@localhost;


create user joseph@localhost identified by 'lsucs123';
create user leo@localhost identified by 'lsucs123';
create user angel@localhost identified by 'lsucs123';
create user jack@localhost identified by 'lsucs123';
create user matthew@localhost identified by 'lsucs123';
create user allan@localhost identified by 'lsucs123';
create user michael@localhost identified by 'lsucs123';
create user erick@localhost identified by 'lsucs123';
create user jeharli@localhost identified by 'lsucs123';
create user jodi@localhost identified by 'lsucs123';
create user morgan@localhost identified by 'lsucs123';
create user terrance@localhost identified by 'lsucs123';

grant all privileges on `joseph%`.* to joseph@localhost;
grant all privileges on `leo%`.* to leo@localhost;
grant all privileges on `angel%`.* to angel@localhost;
grant all privileges on `jack%`.* to jack@localhost;
grant all privileges on `matthew%`.* to matthew@localhost;
grant all privileges on `allan%`.* to allan@localhost;
grant all privileges on `michael%`.* to michael@localhost;
grant all privileges on `erick%`.* to erick@localhost;
grant all privileges on `jeharli%`.* to jeharli@localhost;
grant all privileges on `jodi%`.* to jodi@localhost;
grant all privileges on `morgan%`.* to morgan@localhost;
grant all privileges on `terrance%`.* to terrance@localhost;

run sql script
sudo mysql -u root -p < script.sql







