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