Skip to main content

SHOW USERS

Lists all the users in the system.

Syntax​

SHOW USERS;

Examples​

SHOW USERS;

---
| name                      | hostname | auth_type            | auth_string                              | default_role |
|---------------------------|----------|----------------------|------------------------------------------|--------------|
| sqluser_johnappleseed     | %        | double_sha1_password | 147dee8f648a745805ee8dda80bb8e277559f55b |              |
| johnappleseed@example.com | %        | jwt                  |                                          |              |