Debian Codegraph @

mysql-test/suite/plugins/r/server_audit.result

raw
1 install plugin server_audit soname 'server_audit';
2 show variables like 'server_audit%';
3 Variable_name Value
4 server_audit_events
5 server_audit_excl_users
6 server_audit_file_path server_audit.log
7 server_audit_file_rotate_now OFF
8 server_audit_file_rotate_size 1000000
9 server_audit_file_rotations 9
10 server_audit_incl_users
11 server_audit_logging OFF
12 server_audit_mode 0
13 server_audit_output_type file
14 server_audit_query_log_limit 1024
15 server_audit_syslog_facility LOG_USER
16 server_audit_syslog_ident mysql-server_auditing
17 server_audit_syslog_info
18 server_audit_syslog_priority LOG_INFO
19 set global server_audit_file_path=null;
20 set global server_audit_incl_users=null;
21 set global server_audit_file_path='server_audit.log';
22 set global server_audit_output_type=file;
23 set global server_audit_file_path=REPEAT(REPEAT('new_file_name', 50), 50);
24 Warnings:
25 Warning 1 server_audit_file_path can't exceed FN_LEN characters.
26 set global server_audit_logging=on;
27 set global server_audit_incl_users= repeat("'root',", 10000);
28 ERROR 42000: Variable 'server_audit_incl_users' can't be set to the value of ''root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','...'
29 show variables like 'server_audit_incl_users';
30 Variable_name Value
31 server_audit_incl_users
32 set global server_audit_excl_users= repeat("'root',", 10000);
33 ERROR 42000: Variable 'server_audit_excl_users' can't be set to the value of ''root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','...'
34 show variables like 'server_audit_excl_users';
35 Variable_name Value
36 server_audit_excl_users
37 connect con1,localhost,root,,mysql;
38 disconnect con1;
39 connect(localhost,no_such_user,,mysql,MASTER_PORT,MASTER_SOCKET);
40 connect con1,localhost,no_such_user,,mysql;
41 ERROR 28000: Access denied for user 'no_such_user'@'localhost' (using password: NO)
42 connection default;
43 set global server_audit_incl_users='odin, dva, tri';
44 create table t1 (id int);
45 set global server_audit_incl_users='odin, root, dva, tri';
46 create table t2 (id int);
47 set global server_audit_excl_users='odin, dva, tri';
48 Warnings:
49 Warning 1 User 'odin' is in the server_audit_incl_users, so wasn't added.
50 Warning 1 User 'dva' is in the server_audit_incl_users, so wasn't added.
51 Warning 1 User 'tri' is in the server_audit_incl_users, so wasn't added.
52 insert into t1 values (1), (2);
53 select * from t1;
54 id
55 1
56 2
57 set global server_audit_incl_users='odin, root, dva, tri';
58 insert into t2 values (1), (2);
59 select * from t2;
60 id
61 1
62 2
63 alter table t1 rename renamed_t1;
64 set global server_audit_events='connect,query';
65 select 1,
66 2,
67 # comment
68 3;
69 1 2 3
70 1 2 3
71 insert into t2 values (1), (2);
72 select * from t2;
73 id
74 1
75 2
76 1
77 2
78 select * from t_doesnt_exist;
79 ERROR 42S02: Table 'test.t_doesnt_exist' doesn't exist
80 syntax_error_query;
81 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'syntax_error_query' at line 1
82 drop table renamed_t1, t2;
83 show variables like 'server_audit%';
84 Variable_name Value
85 server_audit_events CONNECT,QUERY
86 server_audit_excl_users
87 server_audit_file_path server_audit.log
88 server_audit_file_rotate_now OFF
89 server_audit_file_rotate_size 1000000
90 server_audit_file_rotations 9
91 server_audit_incl_users odin, root, dva, tri
92 server_audit_logging ON
93 server_audit_mode 0
94 server_audit_output_type file
95 server_audit_query_log_limit 1024
96 server_audit_syslog_facility LOG_USER
97 server_audit_syslog_ident mysql-server_auditing
98 server_audit_syslog_info
99 server_audit_syslog_priority LOG_INFO
100 set global server_audit_mode=1;
101 set global server_audit_events='';
102 create database sa_db;
103 connect con1,localhost,root,,test;
104 create table t1 (id2 int);
105 insert into t1 values (1), (2);
106 select * from t1;
107 id2
108 1
109 2
110 drop table t1;
111 use sa_db;
112 create table sa_t1(id int);
113 insert into sa_t1 values (1), (2);
114 drop table sa_t1;
115 drop database sa_db;
116 disconnect con1;
117 connection default;
118 create database sa_db;
119 use sa_db;
120 CREATE USER u1 IDENTIFIED BY 'pwd-123';
121 GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
122 SET PASSWORD FOR u1 = PASSWORD('pwd 098');
123 CREATE USER u3 IDENTIFIED BY '';
124 ALTER USER u3 IDENTIFIED BY 'pwd-456';
125 GRANT SELECT ON sa_db.* TO pwd_test1 IDENTIFIED BY 'grantpwd789';
126 CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='repl', MASTER_PASSWORD='replsecret';
127 CREATE SERVER pwd_server FOREIGN DATA WRAPPER mysql OPTIONS (HOST 'localhost', USER 'remote', PASSWORD 'serverpwd');
128 ALTER SERVER pwd_server OPTIONS (PASSWORD 'newserverpwd');
129 DROP USER pwd_test1;
130 DROP SERVER pwd_server;
131 RESET SLAVE ALL;
132 drop user u1, u2, u3;
133 set global server_audit_events='query_ddl';
134 create table t1(id int);
135 insert into t1 values (1), (2);
136 select * from t1;
137 id
138 1
139 2
140 select 2;
141 2
142 2
143 (select 2);
144 2
145 2
146 /*! select 2*/;
147 2
148 2
149 /*comment*/ select 2;
150 2
151 2
152 drop table t1;
153 create procedure pr1() insert into test.t1 values ("foo", 42);
154 create function fn1(i int) returns int deterministic return i+1;
155 drop procedure pr1;
156 drop function fn1;
157 set global server_audit_events='query_ddl,query_dml';
158 create table t1(id int);
159 insert into t1 values (1), (2);
160 select * from t1;
161 id
162 1
163 2
164 select 2;
165 2
166 2
167 drop table t1;
168 set global server_audit_events='query_dml';
169 create table t1(id int);
170 insert into t1 values (1), (2);
171 select * from t1;
172 id
173 1
174 2
175 select 2;
176 2
177 2
178 (select 2);
179 2
180 2
181 /*! select 2*/;
182 2
183 2
184 /*comment*/ select 2;
185 2
186 2
187 with foo as (select 1) select 6;
188 6
189 6
190 values (7, 'a'), (8, 'b');
191 7 a
192 7 a
193 8 b
194 #
195 # Certain usage of comments and control characters in query strings bypass audit
196 # logging when filtering in QUERY_{DCL/DML/DDL} mode
197 #
198 -- A comment
199 select 1;
200 1
201 1
202 --A comment
203 select 2;
204 2
205 2
206 # A comment
207 select 3;
208 3
209 3
210 /*! SELECT 4 */;
211 4
212 4
213 /*M! SELECT 5 */;
214 5
215 5
216 /*!100100 SELECT 6 */;
217 6
218 6
219 /*!999999 SELECT 'should not log' */;
220 /*M!100100 SELECT 7 */;
221 7
222 7
223 /*M!999999 SELECT 'should not log' */;
224 drop table t1;
225 set global server_audit_events='query_dcl';
226 create table t1(id int);
227 insert into t1 values (1), (2);
228 select * from t1;
229 id
230 1
231 2
232 CREATE USER u1 IDENTIFIED BY 'pwd-123';
233 GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
234 SET PASSWORD
235 # comment
236 FOR u1 = PASSWORD('pwd 098');
237 SET PASSWORD FOR u1=<secret>;
238 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<secret>' at line 1
239 CREATE USER u3 IDENTIFIED BY '';
240 drop user u1, u2, u3;
241 select 2;
242 2
243 2
244 (select 2);
245 2
246 2
247 /*! select 2*/;
248 2
249 2
250 /*comment*/ select 2;
251 2
252 2
253 drop table t1;
254 set global server_audit_events='query_dml_no_select';
255 create table t1(id int);
256 insert into t1 values (1), (2);
257 select * from t1;
258 id
259 1
260 2
261 select 2;
262 2
263 2
264 drop table t1;
265 create procedure pr1() insert into test.t1 values ("foo", 42);
266 create function fn1(i int) returns int deterministic return i+1;
267 drop procedure pr1;
268 drop function fn1;
269 create procedure pr1() insert into test.t1 values ("foo", 42);
270 create function fn1(i int) returns int deterministic return i+1;
271 drop procedure pr1;
272 drop function fn1;
273 set global server_audit_events='table';
274 set global server_audit_incl_users='user1';
275 create user user1@localhost;
276 grant all on sa_db.* to user1@localhost;
277 connect cn1,localhost,user1,,sa_db;
278 connection cn1;
279 create table t1(id int) engine=myisam;
280 insert delayed into t1 values (1);
281 connection default;
282 # Waiting until INSERT DELAYED thread does the insert.
283 drop table t1;
284 create table test_partitions (i int) partition by hash (i) partitions 4;
285 drop table test_partitions;
286 set global server_audit_logging= off;
287 set global server_audit_incl_users='root';
288 set global server_audit_logging= on;
289 disconnect cn1;
290 drop user user1@localhost;
291 set global server_audit_events='';
292 set global server_audit_incl_users='root, plug_dest';
293 CREATE USER plug IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
294 CREATE USER plug_dest IDENTIFIED BY 'plug_dest_passwd';
295 connect(localhost,plug,plug_dest,test,MYSQL_PORT,MYSQL_SOCK);
296 connect plug_con,localhost,plug,plug_dest;
297 ERROR 28000: Access denied for user 'plug'@'localhost' (using password: YES)
298 GRANT PROXY ON plug_dest TO plug;
299 connect plug_con,localhost,plug,plug_dest,"*NO-ONE*";
300 connection plug_con;
301 select USER(),CURRENT_USER();
302 USER() CURRENT_USER()
303 plug@localhost plug_dest@%
304 connection default;
305 disconnect plug_con;
306 DROP USER plug;
307 DROP USER plug_dest;
308 set global server_audit_query_log_limit= 15;
309 select (1), (2), (3), (4);
310 1 2 3 4
311 1 2 3 4
312 select 'A', 'B', 'C', 'D';
313 A B C D
314 A B C D
315 set global server_audit_query_log_limit= 1024;
316 drop database sa_db;
317 select length('01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789');
318 length('0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456
319 2750
320 CREATE TABLE test.t1 (a char(4));
321 set sql_mode="";
322 insert into test.t1 value("12345");
323 Warnings:
324 Warning 1265 Data truncated for column 'a' at row 1
325 set sql_mode=default;
326 drop table test.t1;
327 set global server_audit_file_path='.';
328 show status like 'server_audit_current_log';
329 Variable_name Value
330 Server_audit_current_log HOME_DIR/server_audit.log
331 set global server_audit_file_path='';
332 show status like 'server_audit_current_log';
333 Variable_name Value
334 Server_audit_current_log server_audit.log
335 set global server_audit_file_path=' ';
336 show status like 'server_audit_current_log';
337 Variable_name Value
338 Server_audit_current_log server_audit.log
339 set global server_audit_file_path='nonexisting_dir/';
340 Warnings:
341 Warning 1 SERVER AUDIT plugin can't create file 'nonexisting_dir/'.
342 show status like 'server_audit_current_log';
343 Variable_name Value
344 Server_audit_current_log server_audit.log
345 show variables like 'server_audit%';
346 Variable_name Value
347 server_audit_events
348 server_audit_excl_users
349 server_audit_file_path
350 server_audit_file_rotate_now OFF
351 server_audit_file_rotate_size 1000000
352 server_audit_file_rotations 9
353 server_audit_incl_users root, plug_dest
354 server_audit_logging ON
355 server_audit_mode 1
356 server_audit_output_type file
357 server_audit_query_log_limit 1024
358 server_audit_syslog_facility LOG_USER
359 server_audit_syslog_ident mysql-server_auditing
360 server_audit_syslog_info
361 server_audit_syslog_priority LOG_INFO
362 uninstall plugin server_audit;
363 Warnings:
364 Warning 1620 Plugin is busy and will be uninstalled on shutdown
365 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0
366 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users= repeat("\'root\',", 10000)',ID
367 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'show variables like \'server_audit_incl_users\'',0
368 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_excl_users= repeat("\'root\',", 10000)',ID
369 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'show variables like \'server_audit_excl_users\'',0
370 TIME,HOSTNAME,root,localhost,ID,0,CONNECT,mysql,,0
371 TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,mysql,,0
372 TIME,HOSTNAME,no_such_user,localhost,ID,0,FAILED_CONNECT,,,ID
373 TIME,HOSTNAME,no_such_user,localhost,ID,0,DISCONNECT,,,0
374 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, dva, tri\'',0
375 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
376 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t2,
377 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create table t2 (id int)',0
378 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_excl_users=\'odin, dva, tri\'',0
379 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'SHOW WARNINGS',0
380 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t1,
381 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
382 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
383 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
384 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
385 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t1,
386 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t1',0
387 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
388 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t2,
389 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
390 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
391 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
392 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
393 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t2,
394 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t2',0
395 TIME,HOSTNAME,root,localhost,ID,ID,ALTER,test,t1,
396 TIME,HOSTNAME,root,localhost,ID,ID,RENAME,test,t1|test.renamed_t1,
397 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
398 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
399 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
400 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'alter table t1 rename renamed_t1',0
401 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_events=\'connect,query\'',0
402 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select 1,\n2,\n# comment\n3',0
403 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
404 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t2',0
405 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t_doesnt_exist',ID
406 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'syntax_error_query',ID
407 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'drop table renamed_t1, t2',0
408 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'show variables like \'server_audit%\'',0
409 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_mode=1',0
410 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_events=\'\'',0
411 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
412 TIME,HOSTNAME,root,localhost,ID,0,CONNECT,test,,0
413 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t1,
414 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create table t1 (id2 int)',0
415 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t1,
416 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
417 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
418 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
419 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
420 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t1,
421 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t1',0
422 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
423 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
424 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
425 TIME,HOSTNAME,root,localhost,ID,ID,DROP,test,t1,
426 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'drop table t1',0
427 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'use sa_db',0
428 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,sa_db,sa_t1,
429 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table sa_t1(id int)',0
430 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,sa_db,sa_t1,
431 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
432 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
433 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
434 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into sa_t1 values (1), (2)',0
435 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
436 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
437 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
438 TIME,HOSTNAME,root,localhost,ID,ID,DROP,sa_db,sa_t1,
439 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table sa_t1',0
440 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,proc,
441 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proc,
442 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,event,
443 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop database sa_db',0
444 TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,,,0
445 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
446 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'use sa_db',0
447 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
448 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
449 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
450 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
451 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
452 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
453 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
454 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
455 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
456 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
457 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
458 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
459 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'SET PASSWORD FOR u1 = PASSWORD(*****)',0
460 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
461 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
462 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
463 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
464 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
465 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
466 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
467 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
468 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
469 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'ALTER USER u3 IDENTIFIED BY *****',0
470 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
471 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
472 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT SELECT ON sa_db.* TO pwd_test1 IDENTIFIED BY *****',0
473 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CHANGE MASTER TO MASTER_HOST=\'127.0.0.1\', MASTER_USER=\'repl\', MASTER_PASSWORD=*****',0
474 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,servers,
475 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE SERVER pwd_server FOREIGN DATA WRAPPER mysql OPTIONS (HOST \'localhost\', USER \'remote\', PASSWORD *****)',0
476 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,servers,
477 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'ALTER SERVER pwd_server OPTIONS (PASSWORD *****)',0
478 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
479 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
480 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
481 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
482 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
483 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
484 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
485 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'DROP USER pwd_test1',0
486 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,servers,
487 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'DROP SERVER pwd_server',0
488 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'RESET SLAVE ALL',0
489 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
490 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
491 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
492 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
493 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
494 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
495 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
496 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
497 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table t1(id int)',0
498 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table t1',0
499 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create procedure pr1() insert into test.t1 values ("foo", 42)',0
500 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create function fn1(i int) returns int deterministic return i+1',0
501 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop procedure pr1',0
502 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop function fn1',0
503 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table t1(id int)',0
504 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
505 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select * from t1',0
506 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select 2',0
507 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table t1',0
508 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
509 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select * from t1',0
510 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select 2',0
511 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'(select 2)',0
512 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*! select 2*/',0
513 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*comment*/ select 2',0
514 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'with foo as (select 1) select 6',0
515 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'values (7, \'a\'), (8, \'b\')',0
516 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'-- A comment\nselect 1',0
517 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'--A comment\nselect 2',0
518 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'# A comment\nselect 3',0
519 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*! SELECT 4 */',0
520 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*M! SELECT 5 */',0
521 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*!100100 SELECT 6 */',0
522 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*M!100100 SELECT 7 */',0
523 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
524 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
525 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
526 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
527 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
528 TIME,HOSTNAME,user1,localhost,ID,ID,CREATE,sa_db,t1,
529 TIME,HOSTNAME,user1,localhost,ID,ID,WRITE,sa_db,t1,
530 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_logging= off',0
531 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
532 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
533 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
534 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
535 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
536 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
537 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
538 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_events=\'\'',0
539 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_incl_users=\'root, plug_dest\'',0
540 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
541 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
542 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
543 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
544 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
545 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
546 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
547 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER plug IDENTIFIED WITH \'test_plugin_server\' AS \'plug_dest\'',0
548 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
549 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
550 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
551 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
552 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
553 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
554 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
555 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER plug_dest IDENTIFIED BY *****',0
556 TIME,HOSTNAME,plug,localhost,ID,0,FAILED_CONNECT,,,ID
557 TIME,HOSTNAME,plug,localhost,ID,0,DISCONNECT,,,0
558 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
559 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
560 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT PROXY ON plug_dest TO plug',0
561 TIME,HOSTNAME,plug,localhost,ID,0,CONNECT,,,0
562 TIME,HOSTNAME,plug,localhost,ID,0,PROXY_CONNECT,,`plug_dest`@`%`,0
563 TIME,HOSTNAME,plug,localhost,ID,ID,QUERY,,'select USER(),CURRENT_USER()',0
564 TIME,HOSTNAME,plug,localhost,ID,0,DISCONNECT,,,0
565 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
566 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
567 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
568 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
569 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
570 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
571 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
572 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'DROP USER plug',0
573 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
574 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
575 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
576 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
577 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
578 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
579 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
580 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'DROP USER plug_dest',0
581 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global serv',0
582 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select (1), (2)',0
583 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select \'A\', ',0
584 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_query_log_limit= 1024',0
585 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,proc,
586 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proc,
587 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,event,
588 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop database sa_db',0
589 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select length(\'012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567',0
590 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t1,
591 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE TABLE test.t1 (a char(4))',0
592 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set sql_mode=""',0
593 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t1,
594 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
595 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
596 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
597 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into test.t1 value("12345")',0
598 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0
599 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set sql_mode=default',0
600 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
601 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
602 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
603 TIME,HOSTNAME,root,localhost,ID,ID,DROP,test,t1,
604 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table test.t1',0
605 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
606 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
607 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
608 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
609 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
610 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
611 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
612 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
613 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
614 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
615 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
616 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0
617 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
618 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show variables like \'server_audit%\'',0
619 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,plugin,
620 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'uninstall plugin server_audit',0
621 #
622 # MDEV-27631 Assertion `global_status_var.global_memory_used == 0' failed in mysqld_exit
623 #
624 install plugin server_audit soname 'server_audit';
625 uninstall plugin server_audit;
626 Warnings:
627 Warning 1620 Plugin is busy and will be uninstalled on shutdown