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

Parameter	Required	Description
user_name	No	The user name. If not specified, the property of the current user is viewed.
property_name	No	The 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.