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 : log_builtin_as_identified_by_password.result

include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	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.
[connection master]
SHOW GLOBAL VARIABLES LIKE 'log_builtin_as_identified_by_password';
Variable_name	Value
log_builtin_as_identified_by_password	ON
#
# Bug#21516392 : PREVENT ACCOUNT MANAGEMENT STATEMENTS FROM
#                INJECTING ACCOUNT ATTRIBUTES
# Bug#20535561 : CREATE USER IN BINLOG WITH
#                LOG_BACKWARD_COMPATIBLE_USER_DEFINITIONS ON
#
[On Master]
CREATE USER u1@localhost PASSWORD EXPIRE NEVER;
CREATE USER u2@localhost ACCOUNT LOCK;
CREATE USER u3@localhost;
CREATE USER u4@localhost IDENTIFIED WITH 'mysql_native_password';
CREATE USER u5@localhost IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF';
CREATE USER u6@localhost IDENTIFIED BY 'abcd';
CREATE USER u7@localhost IDENTIFIED WITH 'mysql_native_password' by 'abcd';
ALTER USER u1@localhost IDENTIFIED BY 'abcd';
ALTER USER u2@localhost ACCOUNT LOCK;
ALTER USER u3@localhost PASSWORD EXPIRE NEVER;
ALTER USER u4@localhost IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF';
ALTER USER u1@localhost PASSWORD EXPIRE;
ALTER USER u2@localhost IDENTIFIED BY 'abcd', u3@localhost PASSWORD EXPIRE;
ALTER USER u4@localhost IDENTIFIED BY 'abcd', u5@localhost ACCOUNT LOCK;
ALTER USER u5@localhost, u6@localhost PASSWORD EXPIRE ACCOUNT LOCK;
DROP USER u1@localhost;
DROP USER u2@localhost;
DROP USER u3@localhost;
DROP USER u4@localhost;
DROP USER u5@localhost;
DROP USER u6@localhost;
DROP USER u7@localhost;
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED BY PASSWORD '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8' PASSWORD EXPIRE NEVER
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED BY PASSWORD '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8' ACCOUNT LOCK
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u3'@'localhost' IDENTIFIED BY PASSWORD '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u4'@'localhost' IDENTIFIED BY PASSWORD '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u5'@'localhost' IDENTIFIED BY PASSWORD '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u6'@'localhost' IDENTIFIED BY PASSWORD '*7957FD7024C720D807B8F2B36F8185F5D2A75A31'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u7'@'localhost' IDENTIFIED BY PASSWORD '*7957FD7024C720D807B8F2B36F8185F5D2A75A31'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u2'@'localhost' ACCOUNT LOCK
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u3'@'localhost' PASSWORD EXPIRE NEVER
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' PASSWORD EXPIRE
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA','u3'@'localhost' PASSWORD EXPIRE
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA','u5'@'localhost' ACCOUNT LOCK
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u5'@'localhost','u6'@'localhost' PASSWORD EXPIRE ACCOUNT LOCK
master-bin.000001	#	Query	#	#	use `test`; DROP USER u1@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u2@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u3@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u4@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u5@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u6@localhost
master-bin.000001	#	Query	#	#	use `test`; DROP USER u7@localhost
include/sync_slave_sql_with_master.inc
[On Slave]
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8' PASSWORD EXPIRE NEVER
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8' ACCOUNT LOCK
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BE1BDEC0AA74B4DCB079943E70528096CCA985F8'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u5'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u6'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*7957FD7024C720D807B8F2B36F8185F5D2A75A31'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*7957FD7024C720D807B8F2B36F8185F5D2A75A31'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u2'@'localhost' ACCOUNT LOCK
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u3'@'localhost' PASSWORD EXPIRE NEVER
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' PASSWORD EXPIRE
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA','u3'@'localhost' PASSWORD EXPIRE
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A154C52565E9E7F94BFC08A1FE702624ED8EFFDA','u5'@'localhost' ACCOUNT LOCK
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u5'@'localhost','u6'@'localhost' PASSWORD EXPIRE ACCOUNT LOCK
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u1@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u2@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u3@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u4@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u5@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u6@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u7@localhost
include/rpl_end.inc

End of 5.7 tests!

${this.title}

Code Editor : log_builtin_as_identified_by_password.result