SHOW USERS

Shows the list of user accounts.

Syntax

SHOW USERS

Examples

SHOW USERS;
+------+----------+----------------------+---------------+
| name | hostname | auth_type            | is_configured |
+------+----------+----------------------+---------------+
| root | %        | double_sha1_password | YES           |
+------+----------+----------------------+---------------+
| test | %        | double_sha1_password | NO            |
+------+----------+----------------------+---------------+