Outdated Version
You are viewing an older version of this section. View current production version.
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
