1SET GLOBAL audit_log_include_commands= 'create_table,create_procedure,create_trigger,insert'; 2SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 3@@audit_log_include_commands @@audit_log_exclude_commands 4create_table,create_procedure,create_trigger,insert NULL 5SET GLOBAL audit_log_exclude_commands= 'alter_db_upgrade,change_db,drop_table,drop_db'; 6ERROR 42000: Variable 'audit_log_exclude_commands' can't be set to the value of 'alter_db_upgrade,change_db,drop_table,drop_db' 7SET GLOBAL audit_log_exclude_commands= NULL; 8ERROR 42000: Variable 'audit_log_exclude_commands' can't be set to the value of 'NULL' 9SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 10@@audit_log_include_commands @@audit_log_exclude_commands 11create_table,create_procedure,create_trigger,insert NULL 12SET GLOBAL audit_log_include_commands= 'alter_db_upgrade,change_db,drop_table,drop_db'; 13SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 14@@audit_log_include_commands @@audit_log_exclude_commands 15alter_db_upgrade,change_db,drop_table,drop_db NULL 16SET GLOBAL audit_log_include_commands= ''; 17SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 18@@audit_log_include_commands @@audit_log_exclude_commands 19 NULL 20SET GLOBAL audit_log_exclude_commands= 'insert,call_procedure,call_procedure,set_option,assign_to_keycache'; 21ERROR 42000: Variable 'audit_log_exclude_commands' can't be set to the value of 'insert,call_procedure,call_procedure,set_option,assign_to_keycache' 22SET GLOBAL audit_log_include_commands= NULL; 23SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 24@@audit_log_include_commands @@audit_log_exclude_commands 25NULL NULL 26SET GLOBAL audit_log_exclude_commands= "insert,call_procedure,call_procedure,set_option,assign_to_keycache"; 27SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 28@@audit_log_include_commands @@audit_log_exclude_commands 29NULL insert,call_procedure,call_procedure,set_option,assign_to_keycache 30SET GLOBAL audit_log_include_commands= 'change_db,drop_table@localhost'; 31ERROR 42000: Variable 'audit_log_include_commands' can't be set to the value of 'change_db,drop_table@localhost' 32SET GLOBAL audit_log_include_commands= NULL; 33ERROR 42000: Variable 'audit_log_include_commands' can't be set to the value of 'NULL' 34SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 35@@audit_log_include_commands @@audit_log_exclude_commands 36NULL insert,call_procedure,call_procedure,set_option,assign_to_keycache 37SET GLOBAL audit_log_exclude_commands= 'change_db,drop_table'; 38SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 39@@audit_log_include_commands @@audit_log_exclude_commands 40NULL change_db,drop_table 41SET GLOBAL audit_log_exclude_commands= ''; 42SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 43@@audit_log_include_commands @@audit_log_exclude_commands 44NULL 45SET GLOBAL audit_log_include_commands= 'change_db'; 46ERROR 42000: Variable 'audit_log_include_commands' can't be set to the value of 'change_db' 47SET GLOBAL audit_log_exclude_commands= NULL; 48SELECT @@audit_log_include_commands, @@audit_log_exclude_commands; 49@@audit_log_include_commands @@audit_log_exclude_commands 50NULL NULL 51SET GLOBAL audit_log_flush=ON; 52SET GLOBAL audit_log_flush=ON; 53SET GLOBAL audit_log_exclude_commands= NULL; 54SET GLOBAL audit_log_include_commands= NULL; 55CREATE DATABASE db1 DEFAULT CHARACTER SET latin1; 56USE db1; 57CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM; 58CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB; 59CREATE PROCEDURE p1() 60BEGIN 61INSERT INTO t1 (a, b) VALUES (1, 1); 62END// 63CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b); 64INSERT INTO t1 VALUES (5,5); 65CALL p1(); 66SET GLOBAL keycache1.key_buffer_size=128*1024; 67CACHE INDEX t1 IN keycache1; 68Table Op Msg_type Msg_text 69db1.t1 assign_to_keycache status OK 70ALTER DATABASE db1 DEFAULT CHARACTER SET utf8; 71ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; 72ERROR 42000: Unknown database '#mysql50#a-b-c' 73USE test; 74DROP TABLE db1.t1; 75DROP DATABASE db1; 76SET GLOBAL audit_log_include_commands= 'set_option,creaTE_DB,CHANGE_DB,CREATE_TABLE,CREATE_TABLE,CREATE_PROCEDURE,CREATE_TRIGger,insert,insert,insert,call_procedure,call_procedure,set_option,assign_to_keycache,alter_db,alter_db_upgrade,change_db,drop_table,drop_db'; 77CREATE DATABASE db1 DEFAULT CHARACTER SET latin1; 78USE db1; 79CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM; 80CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB; 81CREATE PROCEDURE p1() 82BEGIN 83INSERT INTO t1 (a, b) VALUES (1, 1); 84END// 85CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b); 86INSERT INTO t1 VALUES (5,5); 87CALL p1(); 88SET GLOBAL keycache1.key_buffer_size=128*1024; 89CACHE INDEX t1 IN keycache1; 90Table Op Msg_type Msg_text 91db1.t1 assign_to_keycache status OK 92ALTER DATABASE db1 DEFAULT CHARACTER SET utf8; 93ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; 94ERROR 42000: Unknown database '#mysql50#a-b-c' 95USE test; 96DROP TABLE db1.t1; 97DROP DATABASE db1; 98SET GLOBAL audit_log_include_commands= 'set_option,creaTE_DB,CHANGE_DB,assign_to_keycache,alter_db,alter_db_upgrade'; 99CREATE DATABASE db1 DEFAULT CHARACTER SET latin1; 100USE db1; 101CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM; 102CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB; 103CREATE PROCEDURE p1() 104BEGIN 105INSERT INTO t1 (a, b) VALUES (1, 1); 106END// 107CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b); 108INSERT INTO t1 VALUES (5,5); 109CALL p1(); 110SET GLOBAL keycache1.key_buffer_size=128*1024; 111CACHE INDEX t1 IN keycache1; 112Table Op Msg_type Msg_text 113db1.t1 assign_to_keycache status OK 114ALTER DATABASE db1 DEFAULT CHARACTER SET utf8; 115ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; 116ERROR 42000: Unknown database '#mysql50#a-b-c' 117USE test; 118DROP TABLE db1.t1; 119DROP DATABASE db1; 120SET GLOBAL audit_log_include_commands= NULL; 121SET GLOBAL audit_log_exclude_commands= 'set_option,create_db,change_db,create_table,create_table,create_prOCEDURE,CREATE_TRIGGER,INSERT,INSERT,INSERT,CALL_PROCEDURE,CALL_PROCEDUre,set_option,assign_to_keycache,alter_db,alter_db_upgrade,change_db,drop_table,drop_db'; 122CREATE DATABASE db1 DEFAULT CHARACTER SET latin1; 123USE db1; 124CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM; 125CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB; 126CREATE PROCEDURE p1() 127BEGIN 128INSERT INTO t1 (a, b) VALUES (1, 1); 129END// 130CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b); 131INSERT INTO t1 VALUES (5,5); 132CALL p1(); 133SET GLOBAL keycache1.key_buffer_size=128*1024; 134CACHE INDEX t1 IN keycache1; 135Table Op Msg_type Msg_text 136db1.t1 assign_to_keycache status OK 137ALTER DATABASE db1 DEFAULT CHARACTER SET utf8; 138ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; 139ERROR 42000: Unknown database '#mysql50#a-b-c' 140USE test; 141DROP TABLE db1.t1; 142DROP DATABASE db1; 143SET GLOBAL audit_log_exclude_commands= NULL; 144SET GLOBAL audit_log_include_commands= NULL; 145set global audit_log_flush= ON; 146=================================================================== 147"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_flush=ON","root[root] @ localhost []","localhost","","","test" 148"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_exclude_commands= NULL","root[root] @ localhost []","localhost","","","test" 149"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_include_commands= NULL","root[root] @ localhost []","localhost","","","test" 150"Ping","<ID>","<DATETIME>","error","<CONN_ID>",0,"","root[root] @ localhost []","localhost","","","test" 151"Query","<ID>","<DATETIME>","create_db","<CONN_ID>",0,"CREATE DATABASE db1 DEFAULT CHARACTER SET latin1","root[root] @ localhost []","localhost","","","test" 152"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE db1","root[root] @ localhost []","localhost","","","db1" 153"Query","<ID>","<DATETIME>","create_table","<CONN_ID>",0,"CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM","root[root] @ localhost []","localhost","","","db1" 154"Query","<ID>","<DATETIME>","create_table","<CONN_ID>",0,"CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB","root[root] @ localhost []","localhost","","","db1" 155"Query","<ID>","<DATETIME>","create_procedure","<CONN_ID>",0,"CREATE PROCEDURE p1() 156BEGIN 157INSERT INTO t1 (a, b) VALUES (1, 1); 158END","root[root] @ localhost []","localhost","","","db1" 159"Query","<ID>","<DATETIME>","create_trigger","<CONN_ID>",0,"CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 160"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 161"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t1 VALUES (5,5)","root[root] @ localhost []","localhost","","","db1" 162"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 163"Query","<ID>","<DATETIME>","call_procedure","<CONN_ID>",0,"INSERT INTO t1 (a, b) VALUES (1, 1)","root[root] @ localhost []","localhost","","","db1" 164"Query","<ID>","<DATETIME>","call_procedure","<CONN_ID>",0,"CALL p1()","root[root] @ localhost []","localhost","","","db1" 165"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL keycache1.key_buffer_size=128*1024","root[root] @ localhost []","localhost","","","db1" 166"Query","<ID>","<DATETIME>","assign_to_keycache","<CONN_ID>",0,"CACHE INDEX t1 IN keycache1","root[root] @ localhost []","localhost","","","db1" 167"Query","<ID>","<DATETIME>","alter_db","<CONN_ID>",0,"ALTER DATABASE db1 DEFAULT CHARACTER SET utf8","root[root] @ localhost []","localhost","","","db1" 168"Query","<ID>","<DATETIME>","alter_db_upgrade","<CONN_ID>",1049,"ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME","root[root] @ localhost []","localhost","","","db1" 169"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE test","root[root] @ localhost []","localhost","","","test" 170"Query","<ID>","<DATETIME>","drop_table","<CONN_ID>",0,"DROP TABLE db1.t1","root[root] @ localhost []","localhost","","","test" 171"Query","<ID>","<DATETIME>","drop_db","<CONN_ID>",0,"DROP DATABASE db1","root[root] @ localhost []","localhost","","","test" 172"Ping","<ID>","<DATETIME>","error","<CONN_ID>",0,"","root[root] @ localhost []","localhost","","","test" 173"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_include_commands= 'set_option,creaTE_DB,CHANGE_DB,CREATE_TABLE,CREATE_TABLE,CREATE_PROCEDURE,CREATE_TRIGger,insert,insert,insert,call_procedure,call_procedure,set_option,assign_to_keycache,alter_db,alter_db_upgrade,change_db,drop_table,drop_db'","root[root] @ localhost []","localhost","","","test" 174"Query","<ID>","<DATETIME>","create_db","<CONN_ID>",0,"CREATE DATABASE db1 DEFAULT CHARACTER SET latin1","root[root] @ localhost []","localhost","","","test" 175"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE db1","root[root] @ localhost []","localhost","","","db1" 176"Query","<ID>","<DATETIME>","create_table","<CONN_ID>",0,"CREATE TABLE t1 (a INT, b INT, KEY(b)) engine=MyISAM","root[root] @ localhost []","localhost","","","db1" 177"Query","<ID>","<DATETIME>","create_table","<CONN_ID>",0,"CREATE TABLE t2 (a INT, b INT, KEY(b)) engine=InnoDB","root[root] @ localhost []","localhost","","","db1" 178"Query","<ID>","<DATETIME>","create_procedure","<CONN_ID>",0,"CREATE PROCEDURE p1() 179BEGIN 180INSERT INTO t1 (a, b) VALUES (1, 1); 181END","root[root] @ localhost []","localhost","","","db1" 182"Query","<ID>","<DATETIME>","create_trigger","<CONN_ID>",0,"CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 183"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 184"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t1 VALUES (5,5)","root[root] @ localhost []","localhost","","","db1" 185"Query","<ID>","<DATETIME>","insert","<CONN_ID>",0,"INSERT INTO t2 (a, b) VALUES (new.a, new.b)","root[root] @ localhost []","localhost","","","db1" 186"Query","<ID>","<DATETIME>","call_procedure","<CONN_ID>",0,"INSERT INTO t1 (a, b) VALUES (1, 1)","root[root] @ localhost []","localhost","","","db1" 187"Query","<ID>","<DATETIME>","call_procedure","<CONN_ID>",0,"CALL p1()","root[root] @ localhost []","localhost","","","db1" 188"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL keycache1.key_buffer_size=128*1024","root[root] @ localhost []","localhost","","","db1" 189"Query","<ID>","<DATETIME>","assign_to_keycache","<CONN_ID>",0,"CACHE INDEX t1 IN keycache1","root[root] @ localhost []","localhost","","","db1" 190"Query","<ID>","<DATETIME>","alter_db","<CONN_ID>",0,"ALTER DATABASE db1 DEFAULT CHARACTER SET utf8","root[root] @ localhost []","localhost","","","db1" 191"Query","<ID>","<DATETIME>","alter_db_upgrade","<CONN_ID>",1049,"ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME","root[root] @ localhost []","localhost","","","db1" 192"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE test","root[root] @ localhost []","localhost","","","test" 193"Query","<ID>","<DATETIME>","drop_table","<CONN_ID>",0,"DROP TABLE db1.t1","root[root] @ localhost []","localhost","","","test" 194"Query","<ID>","<DATETIME>","drop_db","<CONN_ID>",0,"DROP DATABASE db1","root[root] @ localhost []","localhost","","","test" 195"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_include_commands= 'set_option,creaTE_DB,CHANGE_DB,assign_to_keycache,alter_db,alter_db_upgrade'","root[root] @ localhost []","localhost","","","test" 196"Query","<ID>","<DATETIME>","create_db","<CONN_ID>",0,"CREATE DATABASE db1 DEFAULT CHARACTER SET latin1","root[root] @ localhost []","localhost","","","test" 197"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE db1","root[root] @ localhost []","localhost","","","db1" 198"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL keycache1.key_buffer_size=128*1024","root[root] @ localhost []","localhost","","","db1" 199"Query","<ID>","<DATETIME>","assign_to_keycache","<CONN_ID>",0,"CACHE INDEX t1 IN keycache1","root[root] @ localhost []","localhost","","","db1" 200"Query","<ID>","<DATETIME>","alter_db","<CONN_ID>",0,"ALTER DATABASE db1 DEFAULT CHARACTER SET utf8","root[root] @ localhost []","localhost","","","db1" 201"Query","<ID>","<DATETIME>","alter_db_upgrade","<CONN_ID>",1049,"ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME","root[root] @ localhost []","localhost","","","db1" 202"Query","<ID>","<DATETIME>","change_db","<CONN_ID>",0,"USE test","root[root] @ localhost []","localhost","","","test" 203"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_include_commands= NULL","root[root] @ localhost []","localhost","","","test" 204"Ping","<ID>","<DATETIME>","error","<CONN_ID>",0,"","root[root] @ localhost []","localhost","","","test" 205"Ping","<ID>","<DATETIME>","error","<CONN_ID>",0,"","root[root] @ localhost []","localhost","","","test" 206"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_exclude_commands= NULL","root[root] @ localhost []","localhost","","","test" 207"Query","<ID>","<DATETIME>","set_option","<CONN_ID>",0,"SET GLOBAL audit_log_include_commands= NULL","root[root] @ localhost []","localhost","","","test" 208=================================================================== 209