1create user user1@localhost; 2create role r1 with admin user1@localhost; 3grant all on test.* to r1; 4flush tables; 5select 1; 61 71 8drop role r1; 9drop user user1@localhost; 10