SHOW GROUPS FOR USER
On this page
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 |
Example
SHOW GROUPS FOR USER 'root'@'localhost';
+-------------------------------+
| Groups of user root@localhost |
+-------------------------------+
| group_0 |
+-------------------------------+
1 row in set (0.00 sec)
Related Topics
Last modified: August 18, 2023