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.