SHOW PROPERTY
Description
Views the properties of a user. Currently, only the maximum number of connections can be viewed using this command.
tip
The current user can view its own property. Only users with the user_admin
role can view the property of other users.
Syntax
SHOW PROPERTY [FOR 'user_name'] [LIKE 'max_user_connections']
Parameters
Parameter | Required | Description |
---|---|---|
user_name | No | The user name. If not specified, the property of the current user is viewed. |
max_user_connections | No | The maximum number of connections for a user. |
Examples
Example 1: View the maximum number of connections for the current user.
SHOW PROPERTY;
+----------------------+-------+
| Key | Value |
+----------------------+-------+
| max_user_connections | 10000 |
+----------------------+-------+
Example 2: View the maximum number of connections for user jack
.
SHOW PROPERTY FOR 'jack';
Or
SHOW PROPERTY FOR 'jack' LIKE 'max_user_connections';
+----------------------+-------+
| Key | Value |
+----------------------+-------+
| max_user_connections | 100 |
+----------------------+-------+
See also
SET PROPERTY: Sets the maximum number of connections for a user.