SHOW-PROPERTY

Description

This statement is used to view the attributes of the user

1. SHOW PROPERTY [FOR user] [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.

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.

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%';

Keywords

1. SHOW, PROPERTY

Best Practice