At server side ======================== Edit file: my.cnf ------ log-bin binlog-do-db=cqrlog_common # input the database which should be replicated binlog-do-db=cqrlog001 binlog-do-db=cqrlog002 binlog-do-db=cqrlog003 binlog-do-db=cqrlog004 binlog-ignore-db=mysql # input the database that should be ignored for replication server-id=1 From console: mysql> grant replication slave on *.* to 'replication'@'%' identified by 'passwd123'; mysql> flush privileges; mysql> flush tables with read lock; mysql> show master status; mysql> unlock tables; mysql> show grants; mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.2', MASTER_USER='replication', MASTER_PASSWORD='passwd123'; mysql> start slave; mysql> show slave status\G; At workstation side: ========================= Otherwise all same as at server side, but one console command changed: MariaDB [(none)]> change master to master_host='192.168.1.1', master_user='replication', master_password='passwd123'