1drop database if exists events_test; 2drop database if exists mysqltest_db2; 3create database events_test; 4use events_test; 5create user mysqltest_user1@localhost; 6grant create, insert, select, delete on mysqltest_db2.* 7to mysqltest_user1@localhost; 8create database mysqltest_db2; 9connect conn1,localhost,mysqltest_user1,,mysqltest_db2; 10set autocommit=off; 11select @@autocommit; 12@@autocommit 130 14create table t1 (a varchar(255)) engine=innodb; 15begin work; 16insert into t1 (a) values ("OK: create event: insufficient privileges"); 17create event e1 on schedule every 1 day do select 1; 18ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' 19rollback work; 20select * from t1; 21a 22OK: create event: insufficient privileges 23delete from t1; 24commit work; 25begin work; 26insert into t1 (a) values ("OK: alter event: insufficient privileges"); 27alter event e1 on schedule every 1 day do select 1; 28ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' 29rollback work; 30select * from t1; 31a 32OK: alter event: insufficient privileges 33delete from t1; 34commit work; 35begin work; 36insert into t1 (a) values ("OK: drop event: insufficient privileges"); 37drop event e1; 38ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' 39rollback work; 40select * from t1; 41a 42OK: drop event: insufficient privileges 43delete from t1; 44commit work; 45disconnect conn1; 46connection default; 47drop user mysqltest_user1@localhost; 48drop database mysqltest_db2; 49drop database events_test; 50