MySQL Roles are becoming more and more popular. Therefor, we receive more and more questions related to them.
First I encourage you to read this previous 2 posts:
In this post, I will share you some queries I find useful when using MySQL Roles.
Listing the Roles
The first query allows you to list the Roles created on your MySQL Server and if they are assigned to users, and how many:
SELECT any_value(User) 'Role Name',
IF(any_value(from_user) is NULL,'No', 'Yes') Active,
count(to_user) 'Assigned …[Read more]