SRE文档

深浅模式

https://www.cnblogs.com/MrYang-11-GetKnow/p/15818093.html

1.show ​

官当

1.SHOW CREATE USER ​

sql
SHOW CREATE USER [name1 [, name2 ...] | CURRENT_USER]
SHOW CREATE USER [name1 [, name2 ...] | CURRENT_USER]

2.SHOW GRANTS ​

语法：

sql
SHOW GRANTS [FOR user1 [, user2 ...]] [WITH IMPLICIT] [FINAL]
SHOW GRANTS [FOR user1 [, user2 ...]] [WITH IMPLICIT] [FINAL]

3.SHOW PROCESSLIST ​

sql
SHOW PROCESSLIST [INTO OUTFILE filename] [FORMAT format]
SHOW PROCESSLIST [INTO OUTFILE filename] [FORMAT format]

4.SHOW USERS ​

sql
show users;
show users;

5.SHOW ACCESS ​

Shows all users, roles, profiles, etc. and all their grants.

sql
show access;
show access;

6.SHOW CLUSTER ​

Returns a list of clusters. All available clusters are listed in the system.clusters table

sql
show cluster;
show cluster;

7.SHOW SETTING ​

语法：

sql
SHOW SETTING <name>
SHOW SETTING <name>
sql
SHOW SETTINGS LIKE 'send_timeout';

#ILIKE,支持正则
SHOW SETTINGS ILIKE '%CONNECT_timeout%'
SHOW SETTINGS LIKE 'send_timeout';

#ILIKE,支持正则
SHOW SETTINGS ILIKE '%CONNECT_timeout%'