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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
SELECT * FROM performance_schema.replication_applier_configuration
LIMIT 1;
SELECT * FROM performance_schema.replication_applier_configuration
WHERE desired_delay=12;
SELECT * FROM performance_schema.replication_applier_configuration
WHERE privilege_checks_user=NULL;
SELECT * FROM performance_schema.replication_applier_configuration
WHERE require_row_format="NO";
SELECT * FROM performance_schema.replication_applier_configuration
WHERE require_table_primary_key_check="STREAM";
SELECT * FROM performance_schema.replication_applier_configuration
WHERE assign_gtids_to_anonymous_transactions_type="OFF";
SELECT * FROM performance_schema.replication_applier_configuration
WHERE assign_gtids_to_anonymous_transactions_value=NULL;
INSERT INTO performance_schema.replication_applier_configuration
SET desired_delay=2;
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
INSERT INTO performance_schema.replication_applier_configuration
SET privilege_checks_user="'user'@'%'";
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
INSERT INTO performance_schema.replication_applier_configuration
SET require_row_format="YES";
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
INSERT INTO performance_schema.replication_applier_configuration
SET require_table_primary_key_check="ON";
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
INSERT INTO performance_schema.replication_applier_configuration
SET assign_gtids_to_anonymous_transactions="LOCAL";
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UPDATE performance_schema.replication_applier_configuration
SET desired_delay=12 WHERE desired_delay=2;
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UPDATE performance_schema.replication_applier_configuration
SET privilege_checks_user="'user'@'%'" WHERE privilege_checks_user=NULL;
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UPDATE performance_schema.replication_applier_configuration
SET require_row_format="YES" WHERE require_row_format="NO";
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UPDATE performance_schema.replication_applier_configuration
SET require_table_primary_key_check="OFF" WHERE require_table_primary_key_check="STREAM";
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UPDATE performance_schema.replication_applier_configuration
SET assign_gtids_to_anonymous_transactions="LOCAL" WHERE assign_gtids_to_anonymous_transactions="OFF";
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE desired_delay=12;
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE privilege_checks_user="'user'@'%'";
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE require_row_format="NO";
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE require_table_primary_key_check="STREAM";
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE assign_gtids_to_anonymous_transactions_type="OFF";
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration
WHERE assign_gtids_to_anonymous_transactions_value="OFF";
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
DELETE FROM performance_schema.replication_applier_configuration;
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
LOCK TABLES performance_schema.replication_applier_configuration READ;
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UNLOCK TABLES;
LOCK TABLES performance_schema.replication_applier_configuration WRITE;
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
UNLOCK TABLES;
|
