Skip to main content
Version: 3.1

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​

ParameterRequiredDescription
user_nameNoThe user name. If not specified, the property of the current user is viewed.
max_user_connectionsNoThe 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.