SHOW USERS

Show users on a MemSQL cluster.

Syntax

SHOW USERS

Output

Column Description
User user
Connections connections
Is deleted is deleted
Default resource pool the default resource pool name when user starts a connection

Example

memsql> SHOW USERS;
+----------------------------+-------------+------------+-----------------------+
| User                       | Connections | Is deleted | Default resource pool |
+----------------------------+-------------+------------+-----------------------+
| ''@'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)

Related Topics

Was this article useful?