Organizing and assigning privileges to multiple objects in MySQL
MySQL does not support multiple schema in Database, you must create separate database and grant permissions to roles as per your requirements.