Skip to main content
Version: 3.2

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.