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_user_if_exists.result

call mtr.add_suppression('Corresponding entry in binary log used default authentication.*');
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	OFF
#
# WL#8540: Support IF [NOT] EXISTS clause in CREATE/DROP USER
#
CREATE USER u1@localhost;
CREATE USER IF NOT EXISTS u1@localhost, u2@localhost;
Warnings:
Note	3163	User 'u1'@'localhost' already exists.
ALTER USER IF EXISTS u1@localhost ACCOUNT LOCK;
DROP USER u1@localhost;
DROP USER IF EXISTS u2@localhost;
#
# Bug #21807286: "CREATE USER IF NOT EXISTS" REPORTS AN ERROR
#
CREATE USER IF NOT EXISTS b21807286@localhost IDENTIFIED BY 'haha';
CREATE USER IF NOT EXISTS b21807286@localhost IDENTIFIED BY 'haha2';
Warnings:
Note	3163	User 'b21807286'@'localhost' already exists.
ALTER USER IF EXISTS b21807286@localhost IDENTIFIED BY 'haha3';
ALTER USER IF EXISTS b21807286_not_exists@localhost IDENTIFIED BY 'haha4';
Warnings:
Note	3162	User 'b21807286_not_exists'@'localhost' does not exist.
DROP USER b21807286@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'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' ACCOUNT LOCK
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u1@localhost
slave-bin.000001	#	Query	#	#	use `test`; DROP USER IF EXISTS u2@localhost
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*85D0F19E5598AC04AC7B3FCF5383247D28FB59EF'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*CF18BC9B45678165F755356FBD148E0F84D19A63'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*7B8BEAA4240FE1A214BFAEDD99FB3842E4234E5E'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'b21807286_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*498D18FA98FB65CF8E71D1D9DA5721646499DBD1'
slave-bin.000001	#	Query	#	#	use `test`; DROP USER b21807286@localhost
#
# Bug #25813089: "CREATE USER IF NOT EXISTS SHOULD ALWAYS
#                 BE WRITTEN TO THE BINLOGS"
#
# ------
"Scenario 1: CREATE/ALTER USER IF[NOT]EXISTS FOR A SINGLE USER"
# ------
CREATE USER u1@localhost IDENTIFIED BY 'pass1';
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pass2';
Warnings:
Note	3163	User 'u1'@'localhost' already exists.
ALTER USER u1@localhost IDENTIFIED BY 'pass3';
ALTER USER IF EXISTS u1@localhost IDENTIFIED BY 'pass4';
ALTER USER IF EXISTS u1_not_exists@localhost IDENTIFIED BY 'pass5';
Warnings:
Note	3162	User 'u1_not_exists'@'localhost' does not exist.
DROP USER u1@localhost;
[On Master]
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 WITH 'mysql_native_password' AS '*22A99BA288DB55E8E230679259740873101CD636'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*35B5E90BC4F5AE5D02ED515DF6B61141F24EDA02'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*B718D8767BBACFBCE02BA2669ECCEB05930FF7D7'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*9D3D6FA96FA91117D387A4B990C41F5809A536EE'
master-bin.000001	#	Query	#	#	use `test`; DROP USER u1@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 '*22A99BA288DB55E8E230679259740873101CD636'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*35B5E90BC4F5AE5D02ED515DF6B61141F24EDA02'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*B718D8767BBACFBCE02BA2669ECCEB05930FF7D7'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*9D3D6FA96FA91117D387A4B990C41F5809A536EE'
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u1@localhost
"Creating a user only on slave"
CREATE USER IF NOT EXISTS slave_user@localhost IDENTIFIED BY 'slave_pass';
# ------
"Scenario 2: CREATE/ALTER USER IF[NOT]EXISTS FOR MULTIPLE USERS"
# ------
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pass1',
u2@localhost IDENTIFIED BY 'pass2';
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pass1',
u2@localhost IDENTIFIED BY 'pass2',
u3@localhost IDENTIFIED BY 'pass3';
Warnings:
Note	3163	User 'u1'@'localhost' already exists.
Note	3163	User 'u2'@'localhost' already exists.
ALTER USER IF EXISTS u1@localhost IDENTIFIED BY 'pass4',
u2@localhost IDENTIFIED BY 'pass5',
u3@localhost IDENTIFIED BY 'pass6',
u4_not_exists@localhost IDENTIFIED BY 'pass7',
slave_user@localhost IDENTIFIED BY 'pass8';
Warnings:
Note	3162	User 'u4_not_exists'@'localhost' does not exist.
Note	3162	User 'slave_user'@'localhost' does not exist.
DROP USER IF EXISTS u1@localhost, u2@localhost, u3@localhost, slave_user@localhost;
Warnings:
Note	3162	User 'slave_user'@'localhost' does not exist.
[On Master]
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*22A99BA288DB55E8E230679259740873101CD636','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*22A99BA288DB55E8E230679259740873101CD636','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6','u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*35B5E90BC4F5AE5D02ED515DF6B61141F24EDA02'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*B718D8767BBACFBCE02BA2669ECCEB05930FF7D7','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*9D3D6FA96FA91117D387A4B990C41F5809A536EE','u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*E4744236E26ADD8C3C3D727C7851A097FBBB8A87','u4_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BEA19EBE4ACA6B1820BF580B4054EB6B5B0D198D','slave_user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*F40D7E5342EC4960531243A96CC2E94079BC11B7'
master-bin.000001	#	Query	#	#	use `test`; DROP USER IF EXISTS u1@localhost, u2@localhost, u3@localhost, slave_user@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 IF NOT EXISTS 'slave_user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*A8204EFAFFB19DEF65BE70042A9D93F1971925BC'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*22A99BA288DB55E8E230679259740873101CD636','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*22A99BA288DB55E8E230679259740873101CD636','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1B884EF334D678B0743C8CE0425F980669D8FBB6','u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*35B5E90BC4F5AE5D02ED515DF6B61141F24EDA02'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*B718D8767BBACFBCE02BA2669ECCEB05930FF7D7','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*9D3D6FA96FA91117D387A4B990C41F5809A536EE','u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*E4744236E26ADD8C3C3D727C7851A097FBBB8A87','u4_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BEA19EBE4ACA6B1820BF580B4054EB6B5B0D198D','slave_user'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*F40D7E5342EC4960531243A96CC2E94079BC11B7'
slave-bin.000001	#	Query	#	#	use `test`; DROP USER IF EXISTS u1@localhost, u2@localhost, u3@localhost, slave_user@localhost
include/stop_slave_io.inc
# ------
"Scenario 3: CREATE/ALTER USER IF[NOT]EXISTS WITH"
"AUTHENTICATION PLUGIN PROVIDED EXPLICITLY"
# ------
include/rpl_restart_server.inc [server_number=1 parameters: --default_authentication_plugin=sha256_password]
include/start_slave_io.inc
include/rpl_reset.inc
SHOW VARIABLES LIKE 'default_authentication_plugin';
Variable_name	Value
default_authentication_plugin	sha256_password
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED WITH mysql_native_password by 'pass_native';
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED WITH mysql_native_password by 'pass_native2';
Warnings:
Note	3163	User 'u1'@'localhost' already exists.
ALTER USER IF EXISTS u1@localhost IDENTIFIED WITH mysql_native_password BY 'pass_native3';
ALTER USER IF EXISTS u2_not_exists@localhost IDENTIFIED WITH mysql_native_password BY 'pass_native4';
Warnings:
Note	3162	User 'u2_not_exists'@'localhost' does not exist.
SELECT user,authentication_string FROM mysql.user WHERE user='u1';
user	authentication_string
u1	*52BA180A884483D54A3CEB45FB50D4E5B8071399
DROP USER u1@localhost;
[On Master]
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6DD89A65903AC3BCC4873BA43D17EFFB912C67EE'
master-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*AD3E6D897B165BF1FA7D3583FA1FF6AF31FA3C4B'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*52BA180A884483D54A3CEB45FB50D4E5B8071399'
master-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u2_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*53ED7183CBBC6D9995663DD96EFFA60E2CE2C96E'
master-bin.000001	#	Query	#	#	use `test`; DROP USER u1@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 IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6DD89A65903AC3BCC4873BA43D17EFFB912C67EE'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*AD3E6D897B165BF1FA7D3583FA1FF6AF31FA3C4B'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*52BA180A884483D54A3CEB45FB50D4E5B8071399'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u2_not_exists'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*53ED7183CBBC6D9995663DD96EFFA60E2CE2C96E'
slave-bin.000001	#	Query	#	#	use `test`; DROP USER u1@localhost
#
# Bug26680035:  CREATE/ALTER USER ERRORS OUT BUT GETS RECORDED IN
#               THE BINARY LOG
#
call mtr.add_suppression("Following users were specified in CREATE USER IF NOT EXISTS but they already exist. *");
# ------
"Scenario 1: CREATE USER WITH INVALID PLUGIN"
# ------
#
# Step 1.1) Create user with invalid plugin.
#
CREATE USER u1@localhost IDENTIFIED WITH 'plugin1';
ERROR HY000: Plugin 'plugin1' is not loaded
#
# Step 1.2) Create user having 'if not exists' clause with invalid
#           plugin.
#
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED WITH 'plugin2';
ERROR HY000: Plugin 'plugin2' is not loaded
include/assert.inc [assert that the above events are not written to binlog]
# ------
"Scenario 2: ALTER USER WITH INVALID PLUGIN"
# ------
CREATE USER u2@localhost;
#
# Step 2.1) Alter user with invalid plugin.
#
ALTER USER u2@localhost IDENTIFIED WITH 'plugin3';
ERROR HY000: Plugin 'plugin3' is not loaded
#
# Step 2.2) Alter user having 'if exists' clause with invalid plugin.
#
ALTER USER IF EXISTS u2@localhost IDENTIFIED WITH 'plugin4';
ERROR HY000: Plugin 'plugin4' is not loaded
include/assert.inc [assert that the above events are not written to binlog]
# ------
"Scenario 3: CREATE/ALTER USER INVALID PLUGIN WITH MULTIPLE USERS"
# ------
#
# Step 3) Create/Alter user having multiple users with invalid plugin.
#
CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED WITH 'shsh',
u2@localhost IDENTIFIED BY 'pass',
u3@localhost IDENTIFIED WITH 'sha256_password';
ERROR HY000: Plugin 'shsh' is not loaded
ALTER USER IF EXISTS u1@localhost IDENTIFIED WITH 'shsh',
u2@localhost IDENTIFIED BY 'xyz',
u3@localhost IDENTIFIED WITH 'sha256_password';
ERROR HY000: Plugin 'shsh' is not loaded
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password'
slave-bin.000001	#	Query	#	#	use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'shsh','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7','u3'@'localhost' IDENTIFIED WITH 'sha256_password'
slave-bin.000001	#	Query	#	#	use `test`; ALTER USER IF EXISTS 'u1'@'localhost' IDENTIFIED WITH 'shsh','u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*39C549BDECFBA8AFC3CE6B948C9359A0ECE08DE2','u3'@'localhost' IDENTIFIED WITH 'sha256_password'
#
# Step 4) Cleanup
#
DROP USER u2@localhost,u3@localhost;
# Search warnings in the server log
include/rpl_end.inc

End of 5.7 tests!

${this.title}

Code Editor : binlog_user_if_exists.result