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 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

Last modified: August 18, 2023

Was this article helpful?