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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
[connection slave]
CALL mtr.add_suppression("Error reading relay log configuration");
CALL mtr.add_suppression("Failed to create or recover replication info repositories");
CALL mtr.add_suppression("Replica SQL for channel '': Invalid, corrupted PRIVILEGE_CHECKS_USER was found in the replication configuration repository");
CALL mtr.add_suppression("PRIVILEGE_CHECKS_USER for replication channel '' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user");
CALL mtr.add_suppression("Replica: Failed to initialize the connection metadata structure for channel '';");
CALL mtr.add_suppression("Replica SQL for channel '': Replica failed to initialize applier metadata structure from the repository");
CALL mtr.add_suppression("Replica SQL for channel 'ch1': Invalid, corrupted PRIVILEGE_CHECKS_USER was found in the replication configuration repository");
CALL mtr.add_suppression("PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user");
CALL mtr.add_suppression("Replica: Failed to initialize the connection metadata structure for channel 'ch1';");
CALL mtr.add_suppression("Replica SQL for channel 'ch1': Replica failed to initialize applier metadata structure from the repository");
CREATE USER 'replication_applier'@'localhost' IDENTIFIED BY 'password';
GRANT REPLICATION_APPLIER ON * . * TO 'replication_applier'@'localhost';
FLUSH PRIVILEGES;
#
# TC.P.F1: CHANGE MASTER sets the PRIVILEGE_CHECKS_USER correctly.
#
STOP SLAVE;
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER=NULL;
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
FLUSH RELAY LOGS;
START SLAVE;
Warnings:
Warning	1287	'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/assert.inc [Check that mysql.slave_relay_log_info does not have any entry]
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
Matching lines are:
replication_applier
Occurrences of 'replication_applier' in the input file: 1
Matching lines are:
localhost
Occurrences of 'localhost' in the input file: 1
#
# TC.P.F2: PRIVILEGE_CHECKS_USER persists after restarting the server.
#
include/rpl_restart_server.inc [server_number=2]
include/assert.inc [Check that mysql.slave_relay_log_info does not have any entry]
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
Matching lines are:
replication_applier
Occurrences of 'replication_applier' in the input file: 1
Matching lines are:
localhost
Occurrences of 'localhost' in the input file: 1
STOP SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note	3084	Replication thread(s) for channel '' are already stopped.
#
# TC.E.F1: privilege_checks_username has more than 32 length.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='repli_priv_checks_user_more_than_32'@'localhost' FOR CHANNEL "";
ERROR HY000: String 'repli_priv_checks_user_more_than_32' is too long for user name (should be no longer than 32)
include/rpl_stop_server.inc [server_number=2]
include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start --debug=d,simulate_priv_check_username_above_limit]
SELECT * FROM performance_schema.replication_applier_configuration;
CHANNEL_NAME	DESIRED_DELAY	PRIVILEGE_CHECKS_USER	REQUIRE_ROW_FORMAT	REQUIRE_TABLE_PRIMARY_KEY_CHECK	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
	0	<INVALID>	NO	STREAM	OFF	NULL
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
# Removing debug point 'simulate_priv_check_username_above_limit' from @@GLOBAL.debug
START SLAVE FOR CHANNEL "";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
#
# TC.E.F2: privilege_checks_hostname has more than 255 length.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than255' FOR CHANNEL "" ;
ERROR HY000: String 'replication_privilege_checks_hostname_more_than_255_replication_privil' is too long for host name (should be no longer than 255)
include/rpl_stop_server.inc [server_number=2]
include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start --debug=d,simulate_priv_check_hostname_above_limit]
SELECT * FROM performance_schema.replication_applier_configuration;
CHANNEL_NAME	DESIRED_DELAY	PRIVILEGE_CHECKS_USER	REQUIRE_ROW_FORMAT	REQUIRE_TABLE_PRIMARY_KEY_CHECK	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
	0	<INVALID>	NO	STREAM	OFF	NULL
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
# Removing debug point 'simulate_priv_check_hostname_above_limit' from @@GLOBAL.debug
START SLAVE FOR CHANNEL "";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
#
# TC.E.F3: privilege_checks_hostname has @.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'l@calhost' FOR CHANNEL "" ;
ERROR HY000: Malformed hostname (illegal symbol: '@')
include/rpl_stop_server.inc [server_number=2]
include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
Matching lines are:
replication_applier
Occurrences of 'replication_applier' in the input file: 1
Matching lines are:
l@calhost
Occurrences of 'l@calhost' in the input file: 1
SELECT * FROM performance_schema.replication_applier_configuration;
CHANNEL_NAME	DESIRED_DELAY	PRIVILEGE_CHECKS_USER	REQUIRE_ROW_FORMAT	REQUIRE_TABLE_PRIMARY_KEY_CHECK	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
	0	<INVALID>	NO	STREAM	OFF	NULL
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
#
# TC.E.F5. privilege_checks_username is anonymous.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER=''@'localhost' FOR CHANNEL "" ;
ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel '' was set to ``@`localhost`, but anonymous users are disallowed for PRIVILEGE_CHECKS_USER.
include/rpl_stop_server.inc [server_number=2]
include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
SELECT * FROM performance_schema.replication_applier_configuration;
CHANNEL_NAME	DESIRED_DELAY	PRIVILEGE_CHECKS_USER	REQUIRE_ROW_FORMAT	REQUIRE_TABLE_PRIMARY_KEY_CHECK	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
	0	<INVALID>	NO	STREAM	OFF	NULL
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
#
# TC.E.F6. privilege_checks_user is a non existent user.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier_nonexist'@'localhost' FOR CHANNEL "" ;
ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel '' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user.
include/rpl_stop_server.inc [server_number=2]
include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
Matching lines are:
replication_applier_nonexist
Occurrences of 'replication_applier_nonexist' in the input file: 1
Matching lines are:
localhost
Occurrences of 'localhost' in the input file: 1
SELECT * FROM performance_schema.replication_applier_configuration;
CHANNEL_NAME	DESIRED_DELAY	PRIVILEGE_CHECKS_USER	REQUIRE_ROW_FORMAT	REQUIRE_TABLE_PRIMARY_KEY_CHECK	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE	ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
	0	<INVALID>	NO	STREAM	OFF	NULL
include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
include/assert_grep.inc [Found 4 warning in the error log]
include/assert_grep.inc [Found 1 warning in the error log]
#
# Restart slave with TABLE repository to test with privilege_checks_user config.
#
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --debug=d,simulate_priv_check_user_nullptr_t]
include/assert.inc [Check that mysql.slave_relay_log_info has 1 entries for 1 channels]
include/assert.inc [Check that performance_schema.replication_applier_configuration has 1 entries for 1 channels]
include/assert.inc [Check that priv_chks_username for channel "" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "" is correct]
#
# TC.P.T1: CHANGE MASTER sets the PRIVILEGE_CHECKS_USER correctly.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11, PRIVILEGE_CHECKS_USER=NULL FOR CHANNEL "ch1";
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost' FOR CHANNEL "ch2" ;
FLUSH RELAY LOGS FOR CHANNEL "ch1";
FLUSH RELAY LOGS FOR CHANNEL "ch2";
include/assert.inc [Check that mysql.slave_relay_log_info has 3 entries for 3 channels]
include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
#
# TC.P.T2: PRIVILEGE_CHECKS_USER persists after restarting the server.
#
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE]
include/assert.inc [Check that mysql.slave_relay_log_info has 3 entries for 3 channels]
include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
#
# TC.P.T3: RESET SLAVE should keep value of PRIVILEGE_CHECKS_USER.
#
RESET SLAVE FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/assert.inc [Check that mysql.slave_relay_log_info has 2 entries for 2 channels]
include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
include/assert.inc [Check that priv_chks_user for channel "" is correct]
include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
RESET SLAVE ALL FOR CHANNEL "";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
RESET SLAVE ALL FOR CHANNEL "ch2";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
STOP SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note	3084	Replication thread(s) for channel 'ch1' are already stopped.
#
# TC.E.T1: privilege_checks_username has more than 32 length.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='repli_priv_checks_user_more_than_32'@'localhost' FOR CHANNEL "ch1";
ERROR HY000: String 'repli_priv_checks_user_more_than_32' is too long for user name (should be no longer than 32)
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="repl_priv_chcks_usr_more_than_32", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start --debug=d,simulate_priv_check_username_above_limit,simulate_priv_check_user_nullptr_t]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
# Removing debug point 'simulate_priv_check_username_above_limit' from @@GLOBAL.debug
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
#
# TC.E.T2: privilege_checks_hostname has more than 255 length.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than255' FOR CHANNEL "ch1" ;
ERROR HY000: String 'replication_privilege_checks_hostname_more_than_255_replication_privil' is too long for host name (should be no longer than 255)
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="replication_applier", Privilege_checks_hostname="replication_applier_hostname_more_than_255" WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start --debug=d,simulate_priv_check_hostname_above_limit,simulate_priv_check_user_nullptr_t]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
# Removing debug point 'simulate_priv_check_hostname_above_limit' from @@GLOBAL.debug
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
#
# TC.E.T3: privilege_checks_hostname has @.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'l@calhost' FOR CHANNEL "ch1" ;
ERROR HY000: Malformed hostname (illegal symbol: '@')
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username='replication_applier', Privilege_checks_hostname='l@calhost' WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
#
# TC.E.T4. privilege_checks_username is NULL and
#
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username=NULL, Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
#
# TC.E.T5. privilege_checks_username is anonymous.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER=''@'localhost' FOR CHANNEL "ch1" ;
ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to ``@`localhost`, but anonymous users are disallowed for PRIVILEGE_CHECKS_USER.
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
#
# TC.E.T6. privilege_checks_user is a non existent user.
#
CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier_nonexist'@'localhost' FOR CHANNEL "ch1" ;
ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user.
BEGIN;
UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="replication_applier_nonexist", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
COMMIT;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
START SLAVE FOR CHANNEL "ch1";
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE FOR CHANNEL "ch1";
Warnings:
Warning	1287	'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1", SOURCE_PORT=11 FOR CHANNEL "ch1";
include/assert_grep.inc [Found 5 warning in the error log]
include/assert_grep.inc [Found 1 warning in the error log]
DROP USER 'replication_applier'@'localhost';
include/stop_slave.inc
Warnings:
Note	3084	Replication thread(s) for channel 'ch1' are already stopped.
RESET REPLICA ALL;
SET @@global.relay_log_info_repository=FILE;
Warnings:
Warning	1287	'@@relay_log_info_repository' is deprecated and will be removed in a future release.
CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST="127.0.0.1", SOURCE_PORT=MASTER_MYPORT;;
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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
include/start_slave.inc
include/rpl_end.inc