Group 2: login Mysql server by the following methods: (1) CMD (2) HeidiSQL Mysql -h localhost -u root -p Group 3: Create a user of mysql by the following approach identified by 'PSW' Group 4: Grant&Revoke [with grant option]; Create User sername'a'hostname' Grant priv type on database.table to user Revoke priv_type on database.table from user Group 5: Role Create role myrole; Grant select on emp to myrole; Grant myrole to xiaozhang; Set role myrole; Group 6 Sysnthesis problem Assume there is a artwork management system involving the following tables: emp, dept Design two roles : MRole is admin role and another role is employee role, give them resonable access privileges to the two tables and system privileges respectively; 2 Let the two roles including at least one user respectively(Maybe you should create user) 3, Verify your privilege setting. E2 Basic SQL Application based on Mysql