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