Outdated Version

You are viewing an older version of this section. View current production version.

SHOW USERS

Show users on a MemSQL cluster.

SHOW USERS

Output

Column Description
User user
Connections connections
Is deleted is deleted

Example

memsql> SHOW USERS;
+----------------------------+-------------+------------+
| User                       | Connections | Is deleted |
+----------------------------+-------------+------------+
| ''@'127.0.0.1'             |           0 |            |
| ''@'localhost'             |           0 |            |
| 'admin'@'%'                |           0 |            |
| 'admin'@'localhost'        |           0 |            |
| 'dashboard'@'%'            |           0 |            |
| 'dashboard'@'localhost'    |           0 |            |
| 'distributed'@'%'          |           0 |            |
| 'distributed'@'10.0.0.129' |           2 |            |
| 'distributed'@'localhost'  |           0 |            |
| 'root'@'%'                 |           3 |            |
| 'root'@'localhost'         |           1 |            |
+----------------------------+-------------+------------+
11 rows in set (0.00 sec)