Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_anonymous_ownership.res...	15.33 KB	-rw-r--r--
binlog_bug23533.result	486 B	-rw-r--r--
binlog_bug36391.result	143 B	-rw-r--r--
binlog_cache_write_failure.res...	2.4 KB	-rw-r--r--
binlog_check_flush_log_asserti...	595 B	-rw-r--r--
binlog_checksum.result	697 B	-rw-r--r--
binlog_crash_safe_master_check...	1.15 KB	-rw-r--r--
binlog_database.result	9.67 KB	-rw-r--r--
binlog_delete_and_flush_index....	1.73 KB	-rw-r--r--
binlog_dmls_on_tmp_tables_read...	1.88 KB	-rw-r--r--
binlog_drop_if_exists.result	5.35 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.09 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.76 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	210.68 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	230.58 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	2.26 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	2.69 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	248.24 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	227.62 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	231.98 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	155.86 KB	-rw-r--r--
binlog_error_action.result	7.88 KB	-rw-r--r--
binlog_flush_logs_error.result	477 B	-rw-r--r--
binlog_foreign_key_parent_tabl...	566 B	-rw-r--r--
binlog_format_switch_in_tmp_ta...	2.65 KB	-rw-r--r--
binlog_grant.result	1.51 KB	-rw-r--r--
binlog_grant_alter_user.result	76.65 KB	-rw-r--r--
binlog_group_commit_flush_cras...	912 B	-rw-r--r--
binlog_group_commit_gtid_order...	1.3 KB	-rw-r--r--
binlog_group_commit_indefinite...	499 B	-rw-r--r--
binlog_group_commit_sync_delay...	599 B	-rw-r--r--
binlog_group_commit_sync_delay...	285 B	-rw-r--r--
binlog_group_commit_sync_no_de...	2.16 KB	-rw-r--r--
binlog_gtid_automatic_using_ro...	496 B	-rw-r--r--
binlog_gtid_cache.result	5 B	-rw-r--r--
binlog_gtid_errors.result	9.86 KB	-rw-r--r--
binlog_gtid_exhausted.result	1.26 KB	-rw-r--r--
binlog_gtid_implicit_commit.re...	12.4 KB	-rw-r--r--
binlog_gtid_innodb.result	6.31 KB	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	1.7 KB	-rw-r--r--
binlog_gtid_mix_response_packe...	3.69 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	10.7 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row.re...	208.56 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...	244.07 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...	245.21 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_start_...	45.14 KB	-rw-r--r--
binlog_gtid_mysqldump.result	657 B	-rw-r--r--
binlog_gtid_next_begin_caused_...	1.4 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	1.31 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	6.7 KB	-rw-r--r--
binlog_gtid_next_single_stmt_t...	9.6 KB	-rw-r--r--
binlog_gtid_next_temporary_tab...	1.1 KB	-rw-r--r--
binlog_gtid_next_xa.result	36.07 KB	-rw-r--r--
binlog_gtid_ps_reprepare.resul...	3.06 KB	-rw-r--r--
binlog_gtid_purge_binlog_at_st...	597 B	-rw-r--r--
binlog_gtid_rbr_only_flag.resu...	1.63 KB	-rw-r--r--
binlog_gtid_reset_consistency_...	586 B	-rw-r--r--
binlog_gtid_row_ctype_ucs.resu...	1.43 KB	-rw-r--r--
binlog_gtid_simple_recovery.re...	1.82 KB	-rw-r--r--
binlog_gtid_state_update_deadl...	625 B	-rw-r--r--
binlog_gtid_stm_ctype_ucs.resu...	1.53 KB	-rw-r--r--
binlog_gtid_unknown_xid.result	1.21 KB	-rw-r--r--
binlog_gtid_utils.result	13.28 KB	-rw-r--r--
binlog_gtids_table_gcov.result	1.72 KB	-rw-r--r--
binlog_implicit_commit.result	12.4 KB	-rw-r--r--
binlog_incident.result	497 B	-rw-r--r--
binlog_incident_ignore.result	497 B	-rw-r--r--
binlog_index.result	11.61 KB	-rw-r--r--
binlog_innodb.result	6.31 KB	-rw-r--r--
binlog_innodb_row.result	3.12 KB	-rw-r--r--
binlog_killed.result	3.74 KB	-rw-r--r--
binlog_killed_simulate.result	1.19 KB	-rw-r--r--
binlog_max_extension.result	424 B	-rw-r--r--
binlog_max_flush_queue_time_wa...	189 B	-rw-r--r--
binlog_mixed_cache_stat.result	3.2 KB	-rw-r--r--
binlog_mixed_load_data.result	420 B	-rw-r--r--
binlog_mts_logical_clock.resul...	2.92 KB	-rw-r--r--
binlog_mts_logical_clock_gtid....	1.72 KB	-rw-r--r--
binlog_mysqlbinlog-cp932.resul...	358 B	-rw-r--r--
binlog_mysqlbinlog_base64.resu...	1.71 KB	-rw-r--r--
binlog_mysqlbinlog_concat.resu...	488 B	-rw-r--r--
binlog_mysqlbinlog_filter.resu...	1.48 KB	-rw-r--r--
binlog_mysqlbinlog_intvar.resu...	752 B	-rw-r--r--
binlog_mysqlbinlog_raw.result	832 B	-rw-r--r--
binlog_mysqlbinlog_rewrite_db....	1.8 KB	-rw-r--r--
binlog_mysqlbinlog_row.result	211.92 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	244.36 KB	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	245.49 KB	-rw-r--r--
binlog_mysqlbinlog_row_trans.r...	17.45 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	45.18 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop_...	4.07 KB	-rw-r--r--
binlog_nogtid_mix_response_pac...	1.14 KB	-rw-r--r--
binlog_noop_dml_with_readonly....	1.35 KB	-rw-r--r--
binlog_old_versions.result	1.03 KB	-rw-r--r--
binlog_purge_binary_logs_stall...	236 B	-rw-r--r--
binlog_purge_binary_logs_to.re...	309 B	-rw-r--r--
binlog_query_filter_rules.resu...	187 B	-rw-r--r--
binlog_rbr_only_savepoint.resu...	202 B	-rw-r--r--
binlog_reset_connection_not_re...	611 B	-rw-r--r--
binlog_reset_master.result	14 B	-rw-r--r--
binlog_rewrite.result	10.15 KB	-rw-r--r--
binlog_rewrite_db_noleak.resul...	932 B	-rw-r--r--
binlog_rewrite_order.result	4.35 KB	-rw-r--r--
binlog_rewrite_suppress_use.re...	828 B	-rw-r--r--
binlog_rotate_bgc_sync.result	1.54 KB	-rw-r--r--
binlog_rotate_deadlock.result	852 B	-rw-r--r--
binlog_row_binlog.result	39.5 KB	-rw-r--r--
binlog_row_cache_stat.result	3.2 KB	-rw-r--r--
binlog_row_create_select_crash...	446 B	-rw-r--r--
binlog_row_ctype_cp932.result	87.58 KB	-rw-r--r--
binlog_row_ctype_ucs.result	1.43 KB	-rw-r--r--
binlog_row_delete_all_rows.res...	869 B	-rw-r--r--
binlog_row_drop_tbl.result	567 B	-rw-r--r--
binlog_row_drop_tmp_tbl.result	4.86 KB	-rw-r--r--
binlog_row_insert_select.resul...	809 B	-rw-r--r--
binlog_row_kill_create_select....	1.21 KB	-rw-r--r--
binlog_row_mix_innodb_myisam.r...	30.51 KB	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	1.5 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	2.84 KB	-rw-r--r--
binlog_row_query_log_events.re...	442 B	-rw-r--r--
binlog_server_id.result	459 B	-rw-r--r--
binlog_server_start_options.re...	49 B	-rw-r--r--
binlog_set_gtid_mode_ongoing_t...	8.01 KB	-rw-r--r--
binlog_set_trans_dependency_de...	1.29 KB	-rw-r--r--
binlog_sf.result	1.67 KB	-rw-r--r--
binlog_shutdown_hang.result	406 B	-rw-r--r--
binlog_simulate_crash_and_erro...	2.44 KB	-rw-r--r--
binlog_spurious_ddl_errors.res...	2.97 KB	-rw-r--r--
binlog_sql_mode.result	3.69 KB	-rw-r--r--
binlog_start_comment.result	371 B	-rw-r--r--
binlog_start_slave_heartbeat.r...	259 B	-rw-r--r--
binlog_stm_binlog.result	37.96 KB	-rw-r--r--
binlog_stm_blackhole.result	7.78 KB	-rw-r--r--
binlog_stm_cache_stat.result	3.2 KB	-rw-r--r--
binlog_stm_ctype_cp932.result	87.58 KB	-rw-r--r--
binlog_stm_ctype_ucs.result	1.53 KB	-rw-r--r--
binlog_stm_delete_all_rows.res...	873 B	-rw-r--r--
binlog_stm_do_db.result	2.82 KB	-rw-r--r--
binlog_stm_drop_tbl.result	513 B	-rw-r--r--
binlog_stm_drop_tmp_tbl.result	7.11 KB	-rw-r--r--
binlog_stm_insert_select.resul...	762 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.r...	36.05 KB	-rw-r--r--
binlog_stm_ps.result	1.16 KB	-rw-r--r--
binlog_stm_row.result	3.07 KB	-rw-r--r--
binlog_stm_unsafe_warning.resu...	4.8 KB	-rw-r--r--
binlog_stm_user_variables.resu...	5.38 KB	-rw-r--r--
binlog_switch_inside_trans.res...	7.97 KB	-rw-r--r--
binlog_temporary_tables_user_v...	124 B	-rw-r--r--
binlog_tmp_table.result	905 B	-rw-r--r--
binlog_transaction_dependency_...	3.2 KB	-rw-r--r--
binlog_transaction_dependency_...	1.56 KB	-rw-r--r--
binlog_transaction_write_set_s...	1.08 KB	-rw-r--r--
binlog_transaction_write_set_s...	448 B	-rw-r--r--
binlog_transaction_write_set_s...	351 B	-rw-r--r--
binlog_transaction_write_set_s...	1.51 KB	-rw-r--r--
binlog_truncate_kill.result	1.23 KB	-rw-r--r--
binlog_truncate_myisam.result	2.97 KB	-rw-r--r--
binlog_trx_empty_assertions.re...	884 B	-rw-r--r--
binlog_unsafe.result	190.13 KB	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	215.37 KB	-rw-r--r--
binlog_use_gtid_skip.result	311 B	-rw-r--r--
binlog_user_if_exists.result	14.76 KB	-rw-r--r--
binlog_variables_log_bin.resul...	319 B	-rw-r--r--
binlog_variables_log_bin_index...	313 B	-rw-r--r--
binlog_variables_log_statement...	1.03 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	245 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	2.2 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	237 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	590 B	-rw-r--r--
binlog_write_error.result	2.8 KB	-rw-r--r--
binlog_writeset_history_protec...	671 B	-rw-r--r--
binlog_wrong_last_committed.re...	574 B	-rw-r--r--
binlog_xa_handling.result	1.49 KB	-rw-r--r--
binlog_xa_modify_gtid_executed...	2.35 KB	-rw-r--r--
binlog_xa_prepare_failure.resu...	1.05 KB	-rw-r--r--
binlog_xa_prepared_disconnect....	26.74 KB	-rw-r--r--
binlog_xa_rollback_failure.res...	588 B	-rw-r--r--
binlog_xa_select_gtid_executed...	863 B	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	666 B	-rw-r--r--
binlog_xa_trx_split_across_bin...	1016 B	-rw-r--r--
log_builtin_as_identified_by_p...	7.11 KB	-rw-r--r--
show_binlog_events_no_lock.res...	324 B	-rw-r--r--

Code Editor : binlog_rewrite.result

RESET MASTER;
CREATE USER user1@localhost IDENTIFIED BY 'secret';
CREATE USER user2@localhost IDENTIFIED BY 'secret';
SET PASSWORD FOR user1@localhost = 'secret';
# Test the password is encrypted in binary log
# when granting privileges on tables.
GRANT UPDATE ON *.* TO user1@localhost IDENTIFIED BY 'secret' WITH GRANT OPTION;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
GRANT UPDATE ON *.* /*before to*/TO/*after to*/ user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
GRANT UPDATE ON *.* /*before to*/TO/*after to*/ user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before require*/REQUIRE SSL/*after require*/ /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
GRANT UPDATE ON *.* TO user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2';
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
REVOKE UPDATE ON *.* FROM user1@localhost, user2@localhost;
# Test the password is encrypted in binary log
# when granting privileges on procedure.
CREATE PROCEDURE p1() SQL SECURITY INVOKER SELECT 1;
GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before with*/ WITH MAX_QUERIES_PER_HOUR 90;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
GRANT EXECUTE ON PROCEDURE p1 /*before to*/TO/*after to*/ user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before require*/REQUIRE SSL/*after require*/ /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2';
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
REVOKE EXECUTE ON PROCEDURE p1 FROM user1@localhost, user2@localhost;
# Test the password is encrypted in binary log
# when granting privileges on function.
CREATE FUNCTION f1() RETURNS INT RETURN 123;
GRANT EXECUTE ON FUNCTION f1 /*before to*/TO/*after to*/ user1@localhost IDENTIFIED BY 'secret' /*!10000 , user2@localhost IDENTIFIED BY 'secret2' */ /*!99999 THIS_WOULD_BREAK */ /*before require*/REQUIRE SSL/*after require*/ /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
Warnings:
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
Warning	1287	Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation.
REVOKE EXECUTE ON FUNCTION f1 FROM user1@localhost, user2@localhost;
DROP USER user1@localhost, user2@localhost;
DROP FUNCTION f1;
DROP PROCEDURE p1;
GRANT ALL on *.* TO test_user1 IDENTIFIED BY 'azundris1';
Warnings:
Warning	1287	Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement.
CREATE USER test_user2 IDENTIFIED BY 'azundris2';
CHANGE MASTER TO MASTER_PASSWORD='azundris3';
Warnings:
Note	1759	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	1760	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
CREATE USER 'test_user4'@'localhost';
SET PASSWORD FOR 'test_user4'@'localhost' = 'azundris4';
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7'
master-bin.000001	#	Query	#	#	use `test`; GRANT UPDATE ON *.* TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7' WITH GRANT OPTION
master-bin.000001	#	Query	#	#	use `test`; GRANT UPDATE ON *.* TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F' WITH MAX_QUERIES_PER_HOUR 90
master-bin.000001	#	Query	#	#	use `test`; GRANT UPDATE ON *.* TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F' REQUIRE SSL WITH MAX_QUERIES_PER_HOUR 90
master-bin.000001	#	Query	#	#	use `test`; GRANT UPDATE ON *.* TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F'
master-bin.000001	#	Query	#	#	use `test`; REVOKE UPDATE ON *.* FROM user1@localhost, user2@localhost
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
    SQL SECURITY INVOKER
SELECT 1
master-bin.000001	#	Query	#	#	use `test`; GRANT EXECUTE ON PROCEDURE `test`.`p1` TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F' WITH MAX_QUERIES_PER_HOUR 90
master-bin.000001	#	Query	#	#	use `test`; GRANT EXECUTE ON PROCEDURE `test`.`p1` TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F' REQUIRE SSL WITH MAX_QUERIES_PER_HOUR 90
master-bin.000001	#	Query	#	#	use `test`; GRANT EXECUTE ON PROCEDURE `test`.`p1` TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F'
master-bin.000001	#	Query	#	#	use `test`; REVOKE EXECUTE ON PROCEDURE p1 FROM user1@localhost, user2@localhost
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
RETURN 123
master-bin.000001	#	Query	#	#	use `test`; GRANT EXECUTE ON FUNCTION `test`.`f1` TO 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*14E65567ABDB5135D0CFD9A70B3032C179A49EE7','user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*305D7BCA9D65D8D5C4677F05CD2EA2EBE350158F' REQUIRE SSL WITH MAX_QUERIES_PER_HOUR 90
master-bin.000001	#	Query	#	#	use `test`; REVOKE EXECUTE ON FUNCTION f1 FROM user1@localhost, user2@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER user1@localhost, user2@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION f1
master-bin.000001	#	Query	#	#	use `test`; DROP PROCEDURE p1
master-bin.000001	#	Query	#	#	use `test`; GRANT ALL PRIVILEGES ON *.* TO 'test_user1'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*8D15E74BC850D11573A52BE84B504DD0BA40C1E3'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'test_user2'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*A142844DBF024D282D88FE19CB4D3FA13B1E96E0'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'test_user4'@'localhost' IDENTIFIED WITH 'mysql_native_password'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'test_user4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*F62B91C8AD3D5D0BBF02A761A179EA3A66B060EC'
DROP USER 'test_user4'@'localhost';
DROP USER test_user2;
DROP USER test_user1;
End of 5.6 tests!

${this.title}

Code Editor : binlog_rewrite.result