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