Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.219.241.228
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
binlog /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
binlog_anonymous_ownership.tes...
11.78
KB
-rw-r--r--
binlog_bug23533.test
1.48
KB
-rw-r--r--
binlog_bug36391-master.opt
32
B
-rw-r--r--
binlog_bug36391.test
1.18
KB
-rw-r--r--
binlog_cache_write_failure-mas...
97
B
-rw-r--r--
binlog_cache_write_failure.tes...
5.4
KB
-rw-r--r--
binlog_check_flush_log_asserti...
1.68
KB
-rw-r--r--
binlog_checksum.test
1.08
KB
-rw-r--r--
binlog_crash_safe_master_check...
51
B
-rw-r--r--
binlog_crash_safe_master_check...
2.6
KB
-rw-r--r--
binlog_database.test
370
B
-rw-r--r--
binlog_delete_and_flush_index....
3.53
KB
-rw-r--r--
binlog_dmls_on_tmp_tables_read...
2.38
KB
-rw-r--r--
binlog_drop_if_exists.test
3.47
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
2
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
1.75
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
379
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
378
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
1.46
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
3.75
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
314
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
313
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
739
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
409
B
-rw-r--r--
binlog_error_action-master.opt
88
B
-rw-r--r--
binlog_error_action.test
17.12
KB
-rw-r--r--
binlog_flush_logs_error.test
1.72
KB
-rw-r--r--
binlog_foreign_key_parent_tabl...
44
B
-rw-r--r--
binlog_foreign_key_parent_tabl...
1.08
KB
-rw-r--r--
binlog_format_switch_in_tmp_ta...
2.77
KB
-rw-r--r--
binlog_grant.test
1.83
KB
-rw-r--r--
binlog_grant_alter_user-master...
32
B
-rw-r--r--
binlog_grant_alter_user.test
39.59
KB
-rw-r--r--
binlog_group_commit_flush_cras...
51
B
-rw-r--r--
binlog_group_commit_flush_cras...
2.17
KB
-rw-r--r--
binlog_group_commit_gtid_order...
4.6
KB
-rw-r--r--
binlog_group_commit_indefinite...
1.51
KB
-rw-r--r--
binlog_group_commit_sync_delay...
1.84
KB
-rw-r--r--
binlog_group_commit_sync_delay...
1.23
KB
-rw-r--r--
binlog_group_commit_sync_no_de...
3.72
KB
-rw-r--r--
binlog_gtid_automatic_using_ro...
2.02
KB
-rw-r--r--
binlog_gtid_cache-master.opt
117
B
-rw-r--r--
binlog_gtid_cache.test
635
B
-rw-r--r--
binlog_gtid_errors-master.opt
149
B
-rw-r--r--
binlog_gtid_errors.test
9.1
KB
-rw-r--r--
binlog_gtid_exhausted-master.o...
77
B
-rw-r--r--
binlog_gtid_exhausted.test
3.3
KB
-rw-r--r--
binlog_gtid_implicit_commit.te...
121
B
-rw-r--r--
binlog_gtid_innodb.test
132
B
-rw-r--r--
binlog_gtid_mix_ok_packet_all_...
131
B
-rw-r--r--
binlog_gtid_mix_ok_packet_all_...
1.63
KB
-rw-r--r--
binlog_gtid_mix_response_packe...
99
B
-rw-r--r--
binlog_gtid_mix_response_packe...
1.82
KB
-rw-r--r--
binlog_gtid_mode_set_gtid_next...
4.66
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_row.te...
197
B
-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...
707
B
-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...
661
B
-rw-r--r--
binlog_gtid_mysqlbinlog_start_...
444
B
-rw-r--r--
binlog_gtid_mysqldump.test
2.09
KB
-rw-r--r--
binlog_gtid_next_begin_caused_...
948
B
-rw-r--r--
binlog_gtid_next_partially_fai...
2.93
KB
-rw-r--r--
binlog_gtid_next_partially_fai...
9.45
KB
-rw-r--r--
binlog_gtid_next_single_stmt_t...
968
B
-rw-r--r--
binlog_gtid_next_temporary_tab...
2.73
KB
-rw-r--r--
binlog_gtid_next_xa.test
241
B
-rw-r--r--
binlog_gtid_ps_reprepare.test
6.56
KB
-rw-r--r--
binlog_gtid_purge_binlog_at_st...
3.72
KB
-rw-r--r--
binlog_gtid_rbr_only_flag.test
2.51
KB
-rw-r--r--
binlog_gtid_reset_consistency_...
2.61
KB
-rw-r--r--
binlog_gtid_row_ctype_ucs.test
265
B
-rw-r--r--
binlog_gtid_simple_recovery.te...
6
KB
-rw-r--r--
binlog_gtid_state_update_deadl...
2.62
KB
-rw-r--r--
binlog_gtid_stm_ctype_ucs.test
280
B
-rw-r--r--
binlog_gtid_unknown_xid.test
5.39
KB
-rw-r--r--
binlog_gtid_utils.test
3.56
KB
-rw-r--r--
binlog_gtids_table_gcov.test
2.86
KB
-rw-r--r--
binlog_implicit_commit.test
290
B
-rw-r--r--
binlog_incident.test
1.39
KB
-rw-r--r--
binlog_incident_ignore-master....
24
B
-rw-r--r--
binlog_incident_ignore.test
152
B
-rw-r--r--
binlog_index-master.opt
16
B
-rw-r--r--
binlog_index.test
16.86
KB
-rw-r--r--
binlog_innodb-master.opt
25
B
-rw-r--r--
binlog_innodb.test
139
B
-rw-r--r--
binlog_innodb_row.test
2.72
KB
-rw-r--r--
binlog_killed.test
9.71
KB
-rw-r--r--
binlog_killed_simulate-master....
39
B
-rw-r--r--
binlog_killed_simulate.test
2.7
KB
-rw-r--r--
binlog_max_extension.test
2.61
KB
-rw-r--r--
binlog_max_flush_queue_time_wa...
32
B
-rw-r--r--
binlog_max_flush_queue_time_wa...
850
B
-rw-r--r--
binlog_mixed_cache_stat.test
277
B
-rw-r--r--
binlog_mixed_load_data.test
535
B
-rw-r--r--
binlog_mts_logical_clock.test
2.35
KB
-rw-r--r--
binlog_mts_logical_clock_gtid....
318
B
-rw-r--r--
binlog_mysqlbinlog-cp932-maste...
23
B
-rw-r--r--
binlog_mysqlbinlog-cp932.test
1.11
KB
-rw-r--r--
binlog_mysqlbinlog_base64.test
2.64
KB
-rw-r--r--
binlog_mysqlbinlog_concat.test
4.28
KB
-rw-r--r--
binlog_mysqlbinlog_filter.test
2.07
KB
-rw-r--r--
binlog_mysqlbinlog_intvar.test
1.59
KB
-rw-r--r--
binlog_mysqlbinlog_raw.test
3.53
KB
-rw-r--r--
binlog_mysqlbinlog_rewrite_db....
6.58
KB
-rw-r--r--
binlog_mysqlbinlog_row.test
204
B
-rw-r--r--
binlog_mysqlbinlog_row_innodb....
714
B
-rw-r--r--
binlog_mysqlbinlog_row_myisam....
669
B
-rw-r--r--
binlog_mysqlbinlog_row_trans.t...
4.07
KB
-rw-r--r--
binlog_mysqlbinlog_start_stop....
452
B
-rw-r--r--
binlog_mysqlbinlog_start_stop_...
1.95
KB
-rw-r--r--
binlog_nogtid_mix_response_pac...
480
B
-rw-r--r--
binlog_noop_dml_with_readonly....
2.4
KB
-rw-r--r--
binlog_old_versions.test
5.22
KB
-rw-r--r--
binlog_purge_binary_logs_stall...
70
B
-rw-r--r--
binlog_purge_binary_logs_stall...
1.36
KB
-rw-r--r--
binlog_purge_binary_logs_to.te...
3.45
KB
-rw-r--r--
binlog_query_filter_rules-mast...
40
B
-rw-r--r--
binlog_query_filter_rules.test
855
B
-rw-r--r--
binlog_rbr_only_savepoint.test
2.83
KB
-rw-r--r--
binlog_reset_connection_not_re...
3.49
KB
-rw-r--r--
binlog_reset_master.test
996
B
-rw-r--r--
binlog_rewrite.test
2.99
KB
-rw-r--r--
binlog_rewrite_db_noleak.test
2.65
KB
-rw-r--r--
binlog_rewrite_order.test
1.07
KB
-rw-r--r--
binlog_rewrite_suppress_use.te...
2.25
KB
-rw-r--r--
binlog_rotate_bgc_sync.test
3.37
KB
-rw-r--r--
binlog_rotate_deadlock-master....
181
B
-rw-r--r--
binlog_rotate_deadlock.test
1.75
KB
-rw-r--r--
binlog_row_binlog-master.opt
55
B
-rw-r--r--
binlog_row_binlog.test
783
B
-rw-r--r--
binlog_row_cache_stat.test
274
B
-rw-r--r--
binlog_row_create_select_crash...
1.35
KB
-rw-r--r--
binlog_row_ctype_cp932.test
268
B
-rw-r--r--
binlog_row_ctype_ucs.test
272
B
-rw-r--r--
binlog_row_delete_all_rows.tes...
688
B
-rw-r--r--
binlog_row_drop_tbl.test
215
B
-rw-r--r--
binlog_row_drop_tmp_tbl.test
233
B
-rw-r--r--
binlog_row_innodb_stat-master....
26
B
-rw-r--r--
binlog_row_insert_select.test
708
B
-rw-r--r--
binlog_row_kill_create_select....
845
B
-rw-r--r--
binlog_row_mix_innodb_myisam-m...
97
B
-rw-r--r--
binlog_row_mix_innodb_myisam.t...
585
B
-rw-r--r--
binlog_row_mysqlbinlog_db_filt...
4.36
KB
-rw-r--r--
binlog_row_mysqlbinlog_verbose...
5.59
KB
-rw-r--r--
binlog_row_query_log_events.te...
942
B
-rw-r--r--
binlog_server_id.test
794
B
-rw-r--r--
binlog_server_start_options-ma...
54
B
-rw-r--r--
binlog_server_start_options.te...
1.14
KB
-rw-r--r--
binlog_set_gtid_mode_ongoing_t...
6.96
KB
-rw-r--r--
binlog_set_trans_dependency_de...
2.24
KB
-rw-r--r--
binlog_sf.test
2.67
KB
-rw-r--r--
binlog_shutdown_hang.test
1.14
KB
-rw-r--r--
binlog_simulate_crash_and_erro...
4.24
KB
-rw-r--r--
binlog_spurious_ddl_errors-mas...
20
B
-rw-r--r--
binlog_spurious_ddl_errors.tes...
4.16
KB
-rw-r--r--
binlog_sql_mode.test
4.75
KB
-rw-r--r--
binlog_start_comment.test
1.01
KB
-rw-r--r--
binlog_start_slave_heartbeat-s...
16
B
-rw-r--r--
binlog_start_slave_heartbeat.t...
1.33
KB
-rw-r--r--
binlog_stm_binlog-master.opt
55
B
-rw-r--r--
binlog_stm_binlog.test
741
B
-rw-r--r--
binlog_stm_blackhole.test
456
B
-rw-r--r--
binlog_stm_cache_stat.test
280
B
-rw-r--r--
binlog_stm_ctype_cp932.test
318
B
-rw-r--r--
binlog_stm_ctype_ucs.test
287
B
-rw-r--r--
binlog_stm_delete_all_rows.tes...
712
B
-rw-r--r--
binlog_stm_do_db-master.opt
38
B
-rw-r--r--
binlog_stm_do_db.test
2.8
KB
-rw-r--r--
binlog_stm_drop_tbl.test
230
B
-rw-r--r--
binlog_stm_drop_tmp_tbl.test
248
B
-rw-r--r--
binlog_stm_innodb_stat-master....
26
B
-rw-r--r--
binlog_stm_insert_select.test
489
B
-rw-r--r--
binlog_stm_mix_innodb_myisam-m...
145
B
-rw-r--r--
binlog_stm_mix_innodb_myisam.t...
552
B
-rw-r--r--
binlog_stm_ps.test
939
B
-rw-r--r--
binlog_stm_row.test
3.38
KB
-rw-r--r--
binlog_stm_unsafe_warning-mast...
51
B
-rw-r--r--
binlog_stm_unsafe_warning.test
5.65
KB
-rw-r--r--
binlog_stm_user_variables.test
3.4
KB
-rw-r--r--
binlog_switch_inside_trans.tes...
7.63
KB
-rw-r--r--
binlog_temporary_tables_user_v...
1.14
KB
-rw-r--r--
binlog_tmp_table.test
4.53
KB
-rw-r--r--
binlog_transaction_dependency_...
90
B
-rw-r--r--
binlog_transaction_dependency_...
8.21
KB
-rw-r--r--
binlog_transaction_dependency_...
2.2
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.98
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.33
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.21
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
4.15
KB
-rw-r--r--
binlog_truncate_kill.test
1.96
KB
-rw-r--r--
binlog_truncate_myisam.test
348
B
-rw-r--r--
binlog_unsafe-master.opt
65
B
-rw-r--r--
binlog_unsafe.test
25.95
KB
-rw-r--r--
binlog_unsafe_stmt_capable_eng...
41
B
-rw-r--r--
binlog_unsafe_stmt_capable_eng...
12.55
KB
-rw-r--r--
binlog_use_gtid_skip.test
1.03
KB
-rw-r--r--
binlog_user_if_exists.test
9.22
KB
-rw-r--r--
binlog_variables_log_bin-maste...
16
B
-rw-r--r--
binlog_variables_log_bin.test
136
B
-rw-r--r--
binlog_variables_log_bin_index...
70
B
-rw-r--r--
binlog_variables_log_bin_index...
136
B
-rw-r--r--
binlog_variables_log_statement...
2.18
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
879
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
2.45
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
633
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
801
B
-rw-r--r--
binlog_write_error.test
2.7
KB
-rw-r--r--
binlog_writeset_history_protec...
3.06
KB
-rw-r--r--
binlog_wrong_last_committed.te...
3.07
KB
-rw-r--r--
binlog_xa_handling.test
3.69
KB
-rw-r--r--
binlog_xa_modify_gtid_executed...
2.93
KB
-rw-r--r--
binlog_xa_prepare_failure.test
2.05
KB
-rw-r--r--
binlog_xa_prepared_disconnect....
628
B
-rw-r--r--
binlog_xa_rollback_failure.tes...
1.4
KB
-rw-r--r--
binlog_xa_select_gtid_executed...
2.41
KB
-rw-r--r--
binlog_xa_trx_gtid_response_pa...
98
B
-rw-r--r--
binlog_xa_trx_gtid_response_pa...
1.1
KB
-rw-r--r--
binlog_xa_trx_split_across_bin...
2.51
KB
-rw-r--r--
disabled.def
404
B
-rw-r--r--
log_builtin_as_identified_by_p...
39
B
-rw-r--r--
log_builtin_as_identified_by_p...
128
B
-rw-r--r--
show_binlog_events_no_lock.tes...
2.27
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : binlog_noop_dml_with_readonly.test
# ==== Purpose ==== # # Verify that in statement based replication, no operation update query # should not be logged into binlog if the read_only mode is ON. # # ==== Implementation ==== # # 1. Create a table 't' and insert a row in it. # 2. Begin a transaction and execute noop UPDATE query on table 't'. # 3. Start another connection and set super_read_only mode to ON. # 4. Commit the transaction started in step #2. # 5. Clean up. # # ==== References ==== # # Bug #29009092 NOOP UPDATE QUERY IS LOGGED TO BINLOG AFTER READ_ONLY FLAG IS SET --source include/have_binlog_format_statement.inc SET @saved_value_super= @@GLOBAL.SUPER_READ_ONLY; SET @saved_value= @@GLOBAL.read_only; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); # Test-1: Execute only noop UPDATE in the transaction connect (con1,localhost,root,,test); BEGIN; UPDATE t1 SET a = 1 where a =1; connection default; SET GLOBAL SUPER_READ_ONLY=1; connection con1; --error ER_OPTION_PREVENTS_STATEMENT COMMIT; connection default; SET GLOBAL SUPER_READ_ONLY=0; # Test-2: Execute a noop UPDATE and a temporary table INSERT in the transaction connection con1; CREATE TEMPORARY TABLE t2 (a INT) ENGINE=INNODB; BEGIN; UPDATE t1 SET a = 1 where a = 1; INSERT INTO t2 values(10); connection default; SET GLOBAL SUPER_READ_ONLY=1; connection con1; --error ER_OPTION_PREVENTS_STATEMENT COMMIT; DROP TABLE t2; connection default; SET GLOBAL SUPER_READ_ONLY=0; SET GLOBAL READ_ONLY=0; # READ_ONLY does nothing to SUPER users so we setup a non-SUPER user. CREATE USER test@localhost; GRANT CREATE TEMPORARY TABLES, UPDATE, DROP ON *.* TO test@localhost; connect (con2,localhost,test,,test); # Test-3: A non-SUPER user execute only noop UPDATE in the transaction. connection con2; BEGIN; UPDATE t1 SET a = 1 where a =1; connection default; SET GLOBAL READ_ONLY=1; connection con2; --error ER_OPTION_PREVENTS_STATEMENT COMMIT; connection default; SET GLOBAL READ_ONLY=0; # Test-4: A non-SUPER user execute a noop UPDATE and a temporary table # INSERT in the transaction connection con2; CREATE TEMPORARY TABLE t2 (a INT) ENGINE=INNODB; BEGIN; UPDATE t1 SET a = 1 where a = 1; INSERT INTO t2 values(10); connection default; SET GLOBAL READ_ONLY=1; connection con2; --error ER_OPTION_PREVENTS_STATEMENT COMMIT; DROP TABLE t2; # Clean up connection default; DROP USER test@localhost; SET GLOBAL SUPER_READ_ONLY= @saved_value_super; SET GLOBAL read_only= @saved_value; DROP TABLE t1;
Close