SHOW PROPERTY

Description

This statement is used to view user properties

SHOW PROPERTY [FOR user] [LIKE key];

• user

  View the properties of specified user. If not specified, view the properties of current user.

• LIKE

  Fuzzy matching can be performed by name of properties.

Description of return results:

mysql> show property like '%connection%';
+----------------------+-------+
| Key                  | Value |
+----------------------+-------+
| max_user_connections | 100   |
+----------------------+-------+
1 row in set (0.01 sec)

• Key

  Property name.

• Value

  Property value.

Example

1. View the properties of jack user

   SHOW PROPERTY FOR 'jack';

2. View the property of jack user like connection limit

   SHOW PROPERTY FOR 'jack' LIKE '%connection%';

Keywords

SHOW, PROPERTY

​