Skip to main content
Version: Latest-3.3

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 '<property_name>']

Parameters​

ParameterRequiredDescription
user_nameNoThe user name. If not specified, the property of the current user is viewed.
property_nameNoThe user property name.

Examples​

Example 1: View the property the current user.

SHOW PROPERTY;

+----------------------+-------+
| Key                  | Value |
+----------------------+-------+
| max_user_connections | 10000 |
+----------------------+-------+

Example 2: View the property of the user jack.

SHOW PROPERTY FOR 'jack';

Or

SHOW PROPERTY FOR 'jack' LIKE 'max_user_connections';
+----------------------+-------+
| Key                  | Value |
+----------------------+-------+
| max_user_connections | 100   |
+----------------------+-------+

See also​

ALTER USER: Sets properties for a user.