Details
- 
    
Bug
 - 
    Status: Open (View Workflow)
 - 
    
Major
 - 
    Resolution: Unresolved
 - 
    10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
 - 
    None
 
Description
To reproduce in mtr run test case from MDEV-15498 + 
add an option file with --slave_skip_errors=1148 or --slave_skip_errors=all
					--source include/master-slave.inc
			 | 
		
					--source include/have_innodb.inc
			 | 
		
					--source include/have_binlog_format_row.inc
			 | 
		
					 
			 | 
		
					connection slave;  | 
		
					show variables like 'slave_skip_errors';  | 
		
					CREATE USER u@'%' IDENTIFIED BY 'password';  | 
		
					GRANT ALL ON db1.* TO u@'%' IDENTIFIED BY 'password';  | 
		
					flush privileges;  | 
		
					 
			 | 
		
					create database db1;  | 
		
					CREATE TABLE db1.t1c ( id int primary key, msg varchar(100)) ENGINE=innodb;  | 
		
					INSERT INTO db1.t1c VALUES (1, 'initial');  | 
		
					 
			 | 
		
					connection master;  | 
		
					 
			 | 
		
					eval CREATE TABLE test.t1 ( id int primary key, msg varchar(100))  | 
		
					ENGINE=CONNECT DEFAULT CHARSET=utf8  | 
		
					CONNECTION='mysql://u:password@127.0.0.1:$SLAVE_MYPORT/db1/t1c'  | 
		
					  TABLE_TYPE=MYSQL;
			 | 
		
					 
			 | 
		
					select * from test.t1;  | 
		
					 
			 | 
		
					connection master;  | 
		
					--sync_slave_with_master
			 | 
		
					 
			 | 
		
					select * from test.t1;  | 
		
					 
			 | 
		
					connection master;  | 
		
					 
			 | 
		
					insert into test.t1 VALUES(2,'test');  | 
		
					select * from test.t1;  | 
		
					 
			 | 
		
					--sync_slave_with_master
			 | 
		
					 
			 | 
		
					select * from test.t1;  | 
		
					select * from db1.t1c;  | 
		
Attachments
Issue Links
- relates to
 - 
                    
MDEV-15498 replication connect engine Slave: Access denied for user ''@'' (using password: NO) Error_code: 1045
-         
 - Closed
 
 -