MySQL主从复制报Last Errno: 1396

由于生产开启了多线程复制所以错误显示 Coordinator stopped because there were error(s) in the worker(s).
1.可以调整为单线程复制

set global replica_parallel_workers=0
stop slave 
start slave

2.再次查看复制状态
show slave status\G
3.这次可以看出来是用户已经存在

4.把从库存在的用户删除即可

set sql log bin=off;
drop user ‘***’@’localhost’;