Debian Codegraph @

mysql-test/suite/perfschema/r/dml_hosts.result

raw
1 select * from performance_schema.hosts
2 limit 1;
3 select * from performance_schema.hosts
4 where host='FOO';
5 insert into performance_schema.hosts
6 set host='FOO',
7 current_connections=1, total_connections=2;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'hosts'
9 update performance_schema.hosts
10 set current_connections=12;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'hosts'
12 update performance_schema.hosts
13 set current_connections=12 where host like "FOO";
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'hosts'
15 delete from performance_schema.hosts
16 where total_connections=1;
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'hosts'
18 delete from performance_schema.hosts;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'hosts'
20 LOCK TABLES performance_schema.hosts READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'hosts'
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.hosts WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'hosts'
25 UNLOCK TABLES;