1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
CREATE USER test@localhost;
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name;
TABLE_NAME
global_status
global_variables
persisted_variables
processlist
session_account_connect_attrs
session_status
session_variables
variables_info
GRANT SELECT ON performance_schema.cond_instances TO test@localhost;
GRANT SELECT ON performance_schema.setup_consumers TO test@localhost;
GRANT SELECT ON performance_schema.accounts TO test@localhost;
GRANT SELECT ON performance_schema.setup_objects TO test@localhost;
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name;
TABLE_NAME
accounts
cond_instances
global_status
global_variables
persisted_variables
processlist
session_account_connect_attrs
session_status
session_variables
setup_consumers
setup_objects
variables_info
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='performance_schema'
AND TABLE_NAME IN ('accounts', 'cond_instances', 'setup_consumers',
'setup_objects', 'processlist', 'global_status')
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME;
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION
performance_schema accounts USER 1
performance_schema accounts HOST 2
performance_schema accounts CURRENT_CONNECTIONS 3
performance_schema accounts TOTAL_CONNECTIONS 4
performance_schema accounts MAX_SESSION_CONTROLLED_MEMORY 5
performance_schema accounts MAX_SESSION_TOTAL_MEMORY 6
performance_schema cond_instances NAME 1
performance_schema cond_instances OBJECT_INSTANCE_BEGIN 2
performance_schema setup_consumers NAME 1
performance_schema setup_consumers ENABLED 2
performance_schema setup_objects OBJECT_TYPE 1
performance_schema setup_objects OBJECT_SCHEMA 2
performance_schema setup_objects OBJECT_NAME 3
performance_schema setup_objects ENABLED 4
performance_schema setup_objects TIMED 5
REVOKE ALL PRIVILEGES, GRANT OPTION FROM test@localhost;
DROP USER test@localhost;
|
