SHOW-PROPERTY
Description
This statement is used to view the attributes of the user
SHOW PROPERTY [FOR user] [LIKE key]
SHOW ALL PROPERTIES [LIKE key]-
userView the attributes of the specified user. If not specified, check the current user's.
-
LIKEFuzzy matching can be done by attribute name.
-
ALLView the properties of all users (supported since version 2.0.3)
Return result description:
mysql> show property like'%connection%';
+----------------------+-------+
| Key | Value |
+----------------------+-------+
| max_user_connections | 100 |
+----------------------+-------+
1 row in set (0.01 sec)-
KeyProperty name.
-
ValueAttribute value.
mysql> show all properties like "%connection%";
+-------------------+--------------------------------------+
| User | Properties |
+-------------------+--------------------------------------+
| root | {"max_user_connections": "100"} |
| admin | {"max_user_connections": "100"} |
| default_cluster:a | {"max_user_connections": "1000"} |
+-------------------+--------------------------------------+-
Userusername.
-
PropertiesKey: value corresponding to each property of the user.
Example
-
View the attributes of the jack user
SHOW PROPERTY FOR'jack'; -
View the attribute of jack user connection limit
SHOW PROPERTY FOR'jack' LIKE'%connection%'; -
View all users importing cluster related properties
SHOW ALL PROPERTIES LIKE '%load_cluster%'
Keywords
SHOW, PROPERTY, ALL