Debian Codegraph @

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

raw
1 select * from performance_schema.accounts
2 limit 1;
3 select * from performance_schema.accounts
4 where user='FOO' or host='BAR';
5 insert into performance_schema.accounts
6 set user='FOO', host='BAR',
7 current_connections=1, total_connections=2;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
9 update performance_schema.accounts
10 set current_connections=12;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
12 update performance_schema.accounts
13 set current_connections=12 where host like "FOO";
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
15 delete from performance_schema.accounts
16 where total_connections=1;
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
18 delete from performance_schema.accounts;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
20 LOCK TABLES performance_schema.accounts READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.accounts WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`accounts`
25 UNLOCK TABLES;
26 #
27 # MDEV-25325 column_comment for performance_schema tables
28 #
29 select column_name, column_comment
30 from information_schema.columns
31 where table_schema='performance_schema' and table_name='accounts';
32 column_name column_comment
33 USER The connection's client user name for the connection, or NULL if an internal thread.
34 HOST The connection client's host name, or NULL if an internal thread.
35 CURRENT_CONNECTIONS Current connections for the account.
36 TOTAL_CONNECTIONS Total connections for the account.