SHOW-PROPERTY

Description

This statement is used to view the attributes of the user

1. SHOW PROPERTY [FOR user] [LIKE key]
2. SHOW ALL PROPERTIES [LIKE key]
  • user

View the attributes of the specified user. If not specified, check the current user’s. - LIKE

Fuzzy matching can be done by attribute name. - ALL

View the properties of all users (supported since version 2.0.3)

Return result description:

1. mysql> show property like'%connection%';
2. +----------------------+-------+
3. | Key                  | Value |
4. +----------------------+-------+
5. | max_user_connections | 100   |
6. +----------------------+-------+
7. 1 row in set (0.01 sec)
  • Key

Property name. - Value

Attribute value.

1. mysql> show all properties like "%connection%";
2. +-------------------+--------------------------------------+
3. | User              | Properties                           |
4. +-------------------+--------------------------------------+
5. | root              | {"max_user_connections": "100"}      |
6. | admin             | {"max_user_connections": "100"}      |
7. | default_cluster:a | {"max_user_connections": "1000"}     |
8. +-------------------+--------------------------------------+
  • User

username. - Properties

Key: value corresponding to each property of the user.

Example

  1. View the attributes of the jack user

1. SHOW PROPERTY FOR'jack'; 2. View the attribute of jack user connection limit

1. SHOW PROPERTY FOR'jack' LIKE'%connection%'; 3. View all users importing cluster related properties

1. SHOW ALL PROPERTIES LIKE '%load_cluster%'

Keywords

1. SHOW, PROPERTY, ALL

Best Practice