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)
