Creating and Assigning Roles in MySQL
Managing access and granting privileges to individual users can be very time consuming and cumbersome. That is why MySQL provides the ability to create roles. Roles are granted privileges, then roles are assigned to users. The users inherit the privileges of the roles. In this lab, we'll create a set of roles and grant those roles specific privileges. Once the roles have been created, we'll assign them to the appropriate users, in order to grant access to databases and tables within the MySQL server.