MySQL 8 Administrator???s Guide

SET DEFAULT ROLE

SET DEFAULT ROLE indicates which roles are active by default, whenever user login default roles are available to the user. To set a default root, execute the following command:

mysql>SET DEFAULT ROLE app_developer TO root@localhost;mysql> SELECT CURRENT_ROLE();+---------------------+| CURRENT_ROLE() |+---------------------+| `app_developer`@`%` |+---------------------+1 row in set (0.04 sec)

After setting the default role, restart the server and execute the current_role() function to check whether a role is assigned or not.