Skip to main content

SHOW USERS

Shows the list of user accounts.

Syntax​

SHOW USERS

Examples​

SHOW USERS;
+------+----------+----------------------+------------------------------------------+---------------+
| name | hostname | auth_type            | auth_string                              | is_configured |
+------+----------+----------------------+------------------------------------------+---------------+
| root | %        | double_sha1_password | 23ae809ddacaf96af0fd78ed04b6a265e05aa257 | YES           |
+------+----------+----------------------+------------------------------------------+---------------+
| test | %        | double_sha1_password | 3081f32caef285c232d066033c89a78d88a6d8a5 | NO            |
+------+----------+----------------------+------------------------------------------+---------------+