| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/plugins/r/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 35 kB |
|
Quelle server_audit.result Sprache: Lisp |
|||||||||||||||
|
install plugin server_audit soname 'server_audit'; show variables like 'server_audit%'; Variable_name Value server_audit_events server_audit_excl_users server_audit_file_buffer_size 0 server_audit_file_path server_audit.log server_audit_file_rotate_now OFF server_audit_file_rotate_size 1000000 server_audit_file_rotations 9 server_audit_incl_users server_audit_logging OFF server_audit_mode 0 server_audit_output_type file server_audit_query_log_limit 1024 server_audit_sync_log_file OFF server_audit_syslog_facility LOG_USER server_audit_syslog_ident mysql-server_auditing server_audit_syslog_info server_audit_syslog_priority LOG_INFO server_audit_timestamp_format %Y%m%d %H:%i:%s set global server_audit_file_path=null; set global server_audit_incl_users=null; set global server_audit_file_path='server_audit.log'; set global server_audit_output_type=file; set global server_audit_file_path=REPEAT(REPEAT('new_file_name', 50), 50); Warnings: Warning 1 server_audit_file_path can't exceed FN_LEN characters. set global server_audit_logging=on; set global server_audit_incl_users= repeat("'root',", 10000); ERROR 42000: Variable 'server_audit_incl_users' can't be set to the value of ''root','root' show variables like 'server_audit_incl_users'; Variable_name Value server_audit_incl_users set global server_audit_excl_users= repeat("'root',", 10000); ERROR 42000: Variable 'server_audit_excl_users' can't be set to the value of ''root','root' show variables like 'server_audit_excl_users'; Variable_name Value server_audit_excl_users Line count in file: 5 connect con1,localhost,root,,mysql; disconnect con1; Line count in file: 7 connect(localhost,no_such_user,,mysql,MASTER_PORT,MASTER_SOCKET); connect con1,localhost,no_such_user,,mysql; ERROR 28000: Access denied for user 'no_such_user'@'localhost' (using password: NO) Line count in file: 9 connection default; set global server_audit_incl_users='odin, dva, tri'; create table t1 (id int); set global server_audit_incl_users='odin, root, dva, tri'; create table t2 (id int); set global server_audit_excl_users='odin, dva, tri'; Warnings: Warning 1 User 'odin' is in the server_audit_incl_users, so wasn't added. Warning 1 User 'dva' is in the server_audit_incl_users, so wasn't added. Warning 1 User 'tri' is in the server_audit_incl_users, so wasn't added. insert into t1 values (1), (2); select * from t1; id 1 2 set global server_audit_incl_users='odin, root, dva, tri'; insert into t2 values (1), (2); select * from t2; id 1 2 alter table t1 rename renamed_t1; set global server_audit_events='connect,query'; select 1, 2, # comment 3; 1 2 3 1 2 3 insert into t2 values (1), (2); select * from t2; id 1 2 1 2 select * from t_doesnt_exist; ERROR 42S02: Table 'test.t_doesnt_exist' doesn't exist syntax_error_query; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Mari drop table renamed_t1, t2; show variables like 'server_audit%'; Variable_name Value server_audit_events CONNECT,QUERY server_audit_excl_users server_audit_file_buffer_size 0 server_audit_file_path server_audit.log server_audit_file_rotate_now OFF server_audit_file_rotate_size 1000000 server_audit_file_rotations 9 server_audit_incl_users odin, root, dva, tri server_audit_logging ON server_audit_mode 0 server_audit_output_type file server_audit_query_log_limit 1024 server_audit_sync_log_file OFF server_audit_syslog_facility LOG_USER server_audit_syslog_ident mysql-server_auditing server_audit_syslog_info server_audit_syslog_priority LOG_INFO server_audit_timestamp_format %Y%m%d %H:%i:%s set global server_audit_mode=1; set global server_audit_events=''; create database sa_db; Line count in file: 47 connect con1,localhost,root,,test; create table t1 (id2 int); insert into t1 values (1), (2); select * from t1; id2 1 2 drop table t1; use sa_db; create table sa_t1(id int); insert into sa_t1 values (1), (2); drop table sa_t1; drop database sa_db; disconnect con1; Line count in file: 80 connection default; create database sa_db; use sa_db; CREATE USER u1 IDENTIFIED BY 'pwd-123'; GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321"; SET PASSWORD FOR u1 = PASSWORD('pwd 098'); CREATE USER u3 IDENTIFIED BY ''; ALTER USER u3 IDENTIFIED BY 'pwd-456'; GRANT SELECT ON sa_db.* TO pwd_test1 IDENTIFIED BY 'grantpwd789'; CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='repl', MASTER_PASSWORD='replse CREATE SERVER pwd_server FOREIGN DATA WRAPPER mysql OPTIONS (HOST 'localhost', USER 'remote ALTER SERVER pwd_server OPTIONS (PASSWORD 'newserverpwd'); DROP USER pwd_test1; DROP SERVER pwd_server; RESET SLAVE ALL; drop user u1, u2, u3; set global server_audit_events='query_ddl'; create table t1(id int); insert into t1 values (1), (2); select * from t1; id 1 2 select 2; 2 2 (select 2); 2 2 /*! select 2*/; 2 2 /*comment*/ select 2; 2 2 drop table t1; create procedure pr1() insert into test.t1 values ("foo", 42); create function fn1(i int) returns int deterministic return i+1; drop procedure pr1; drop function fn1; set global server_audit_events='query_ddl,query_dml'; create table t1(id int); insert into t1 values (1), (2); select * from t1; id 1 2 select 2; 2 2 drop table t1; set global server_audit_events='query_dml'; create table t1(id int); insert into t1 values (1), (2); select * from t1; id 1 2 select 2; 2 2 (select 2); 2 2 /*! select 2*/; 2 2 /*comment*/ select 2; 2 2 with foo as (select 1) select 6; 6 6 values (7, 'a'), (8, 'b'); 7 a 7 a 8 b # # Certain usage of comments and control characters in query strings bypass audit # logging when filtering in QUERY_{DCL/DML/DDL} mode # -- A comment select 1; 1 1 -- A comment select 2; 2 2 # A comment select 3; 3 3 /*! SELECT 4 */; 4 4 /*M! SELECT 5 */; 5 5 /*!100100 SELECT 6 */; 6 6 /*!999999 SELECT 'should not log' */; /*M!100100 SELECT 7 */; 7 7 /*M!999999 SELECT 'should not log' */; /*!! SELECT 8 */; 8 8 /*!!999999 SELECT 9 */; 9 9 /*!!100100 SELECT 'reversed should not log' */; /*M!!999999 SELECT 10 */; 10 10 /*M!!100100 SELECT 'reversed should not log' */; drop table t1; set global server_audit_events='query_dcl'; create table t1(id int); insert into t1 values (1), (2); select * from t1; id 1 2 CREATE USER u1 IDENTIFIED BY 'pwd-123'; GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321"; SET PASSWORD # comment FOR u1 = PASSWORD('pwd 098'); SET PASSWORD FOR u1=<secret>; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Mari CREATE USER u3 IDENTIFIED BY ''; drop user u1, u2, u3; select 2; 2 2 (select 2); 2 2 /*! select 2*/; 2 2 /*comment*/ select 2; 2 2 drop table t1; set global server_audit_events='query_dml_no_select'; create table t1(id int); insert into t1 values (1), (2); select * from t1; id 1 2 select 2; 2 2 drop table t1; create procedure pr1() insert into test.t1 values ("foo", 42); create function fn1(i int) returns int deterministic return i+1; drop procedure pr1; drop function fn1; create procedure pr1() insert into test.t1 values ("foo", 42); create function fn1(i int) returns int deterministic return i+1; drop procedure pr1; drop function fn1; set global server_audit_events='table'; set global server_audit_incl_users='user1'; create user user1@localhost; grant all on sa_db.* to user1@localhost; connect cn1,127.0.0.1,user1,,sa_db,$MASTER_MYPORT; create table t1(id int) engine=myisam; insert delayed into t1 values (1); connection default; # Waiting until INSERT DELAYED thread does the insert. drop table t1; create table test_partitions (i int) partition by hash (i) partitions 4; drop table test_partitions; set global server_audit_logging= off; set global server_audit_incl_users='root'; set global server_audit_logging= on; disconnect cn1; Line count in file: 169 drop user user1@localhost; set global server_audit_events=''; set global server_audit_incl_users='root, plug_dest, ssl_user1'; CREATE USER plug IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest'; CREATE USER plug_dest IDENTIFIED BY 'plug_dest_passwd'; connect(localhost,plug,plug_dest,test,MYSQL_PORT,MYSQL_SOCK); connect plug_con,localhost,plug,plug_dest; ERROR 28000: Access denied for user 'plug'@'localhost' (using password: YES) GRANT PROXY ON plug_dest TO plug; connect plug_con,localhost,plug,plug_dest,"*NO-ONE*"; select USER(),CURRENT_USER(); USER() CURRENT_USER() plug@localhost plug_dest@% connection default; disconnect plug_con; Line count in file: 203 DROP USER plug; DROP USER plug_dest; CREATE USER ssl_user1@localhost require SSL; GRANT ALL ON sa_db TO ssl_user1@localhost; connect conssl1,localhost,ssl_user1,,sa_db,,,SSL; select variable_value > '' as 'have_ssl' from information_schema.session_status where vari have_ssl 1 disconnect conssl1; Line count in file: 234 connection default; DROP USER ssl_user1@localhost; set global server_audit_query_log_limit= 15; select (1), (2), (3), (4); 1 2 3 4 1 2 3 4 select 'A', 'B', 'C', 'D'; A B C D A B C D set global server_audit_query_log_limit= 1024; drop database sa_db; select length('012345678901234567890123456789012345678901234567890123456789012345 length('012345678901234567890123456789012345678901234567890123456789012345678901 2750 CREATE TABLE test.t1 (a char(4)); set sql_mode=""; insert into test.t1 value("12345"); Warnings: Warning 1265 Data truncated for column 'a' at row 1 set sql_mode=default; drop table test.t1; set global server_audit_file_path='.'; show status like 'server_audit_current_log'; Variable_name Value Server_audit_current_log HOME_DIR/server_audit.log set global server_audit_file_path=''; show status like 'server_audit_current_log'; Variable_name Value Server_audit_current_log server_audit.log set global server_audit_file_path=' '; show status like 'server_audit_current_log'; Variable_name Value Server_audit_current_log server_audit.log set global server_audit_file_path='nonexisting_dir/'; Warnings: Warning 1 SERVER AUDIT plugin can't create file 'nonexisting_dir/'. show status like 'server_audit_current_log'; Variable_name Value Server_audit_current_log server_audit.log show variables like 'server_audit%'; Variable_name Value server_audit_events server_audit_excl_users server_audit_file_buffer_size 0 server_audit_file_path server_audit_file_rotate_now OFF server_audit_file_rotate_size 1000000 server_audit_file_rotations 9 server_audit_incl_users root, plug_dest, ssl_user1 server_audit_logging ON server_audit_mode 1 server_audit_output_type file server_audit_query_log_limit 1024 server_audit_sync_log_file OFF server_audit_syslog_facility LOG_USER server_audit_syslog_ident mysql-server_auditing server_audit_syslog_info server_audit_syslog_priority LOG_INFO server_audit_timestamp_format %Y%m%d %H:%i:%s uninstall plugin server_audit; Warnings: Warning 1620 Plugin is busy and will be uninstalled on shutdown TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_loggin TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_au TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_excl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_au TIME,HOSTNAME,root,localhost:PORT,ID,0,CONNECT,mysql,,0 TIME,HOSTNAME,root,localhost:PORT,ID,0,DISCONNECT,mysql,,0 TIME,HOSTNAME,no_such_user,localhost:PORT,ID,0,FAILED_CONNECT,,,ID TIME,HOSTNAME,no_such_user,localhost:PORT,ID,0,DISCONNECT,,,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t2, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create table t2 (id int)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_excl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'SHOW WARNINGS',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_u TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t2, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t2, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,ALTER,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,RENAME,test,t1|test.renamed_t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'alter table t1 rename renamed_t1 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_events TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select 1,\n2,\n# comment\n3',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t_doesnt_exist',I TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'syntax_error_query',ID TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'drop table renamed_t1, t2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_au TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_mode=1 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_events TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create database sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,0,CONNECT,test,,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create table t1 (id2 int)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'drop table t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'use sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,sa_db,sa_t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table sa_t1(id int)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,sa_db,sa_t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into sa_t1 values (1), (2 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,sa_db,sa_t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table sa_t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,proc, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proc, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,event, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop database sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,0,DISCONNECT,,,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create database sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'use sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *** TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFI TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SET PASSWORD FOR u1 = PASSWORD(* TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *** TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'ALTER USER u3 IDENTIFIED BY **** TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT SELECT ON sa_db.* TO pwd_t TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CHANGE MASTER TO MASTER_HOST=\ TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,servers, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE SERVER pwd_server FOREI TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,servers, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'ALTER SERVER pwd_server OPTION TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER pwd_test1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,servers, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP SERVER pwd_server',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'RESET SLAVE ALL',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table t1(id int)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create procedure pr1() insert i TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create function fn1(i int) retu TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop procedure pr1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop function fn1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table t1(id int)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)', TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select * from t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select 2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)', TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select * from t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select 2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'(select 2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*! select 2*/',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*comment*/ select 2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'with foo as (select 1) select 6', TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'values (7, \'a\'), (8, \'b\')', TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'-- A comment\nselect 1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'-- A comment\nselect 2',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'# A comment\nselect 3',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*! SELECT 4 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*M! SELECT 5 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*!100100 SELECT 6 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*M!100100 SELECT 7 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*!! SELECT 8 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*!! SELECT 9 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*M!! SELECT 10 */',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *** TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFI TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *** TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)', TIME,HOSTNAME,user1,localhost:PORT,ID,ID,CREATE,sa_db,t1, TIME,HOSTNAME,user1,localhost,ID,ID,WRITE,sa_db,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_loggi TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_event TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_incl_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER plug IDENTIFIED WIT TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER plug_dest IDENTIFI TIME,HOSTNAME,plug,localhost:PORT,ID,0,FAILED_CONNECT,,,ID TIME,HOSTNAME,plug,localhost:PORT,ID,0,DISCONNECT,,,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT PROXY ON plug_dest TO plug TIME,HOSTNAME,plug,localhost:PORT,ID,0,CONNECT,,,0 TIME,HOSTNAME,plug,localhost:PORT,ID,0,PROXY_CONNECT,,`plug_dest`@`%`,0 TIME,HOSTNAME,plug,localhost:PORT,ID,ID,QUERY,,'select USER(),CURRENT_USER()',0 TIME,HOSTNAME,plug,localhost:PORT,ID,0,DISCONNECT,,,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER plug',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER plug_dest',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER ssl_user1@localho TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO ssl_user1@ TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,0,CONNECT,sa_db,TLS_VERSION,0 TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW STATUS LIKE \'Ssl_ve TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,ID,QUERY,sa_db,'select variable_value > \' TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,0,DISCONNECT,sa_db,TLS_VERSION,0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER ssl_user1@localhost TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global serv',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select (1), (2)',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select \'A\', ',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_query TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,proc, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proc, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,event, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop database sa_db',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select length(\'012345678901 TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE TABLE test.t1 (a char(4) TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set sql_mode=""',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into test.t1 value("123 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set sql_mode=default',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats, TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,test,t1, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table test.t1',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audi TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audi TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audi TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_ TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0 TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audi TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show variables like \'server_a TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,plugin, TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'uninstall plugin server_audit # # MDEV-27631 Assertion `global_status_var.global_memory_used == 0' failed in mysqld_exit # install plugin server_audit soname 'server_audit'; uninstall plugin server_audit; Warnings: Warning 1620 Plugin is busy and will be uninstalled on shutdown
¤ Dauer der Verarbeitung: 0.18 Sekunden (vorverarbeitet am 2026-10-08) ¤*© Formatika GbR, Deutschland |
|
||||||||||||||
2026-10-10