Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SHOW GROUPS FOR USER
Show groups for a specific user.
Syntax
SHOW GROUPS FOR USER user_specification
user_specification:
user
[
USER 'user_name'
]
Output
| Column | Description |
|---|---|
Groups of user user_name |
groups of user |
Example
SHOW GROUPS FOR USER 'root'@'localhost';
+-------------------------------+
| Groups of user root@localhost |
+-------------------------------+
| group_0 |
+-------------------------------+
1 row in set (0.00 sec)
Related Topics
