use mysql;

grant select, insert, delete, update
on testege.* to 'admin'@'%'
identified by 'teacher_pwd';

grant lock tables
on testege.* to 'admin'@'%';

grant process
on *.*
to 'admin'@'%';

grant usage
on *.* to 'student'@'%'
identified by '12345';

grant select
on testege.* to 'student'@'%';

grant lock tables
on testege.* to 'student'@'%';

grant insert
on testege.person to 'student'@'%';

grant insert
on testege.result to 'student'@'%';

grant insert, update, delete
on testege.answers to 'student'@'%';