Skip to main content

SHOW USERS

Shows the list of user accounts.

Syntax​

SHOW USERS

Examples​

mysql> SHOW USERS;
+------+-----------+----------+-----------+
| name | hostname | password | auth_type |
+------+-----------+----------+-----------+
| test | localhost | password | 3 |
+------+-----------+----------+-----------+