...
Create a replicator user and grant it replication permissions by executing the query below on DB prompt. Replace SLAVE_IP and PASSWORD accordingly to your installationREPLICA_USER, REPLICA_PASS and SLAVE_SERVER as you wish:
Code Block |
---|
GRANT REPLICATION SLAVE ON *.* TO 'replicatorREPLICA_USER'@'SLAVE_IPSERVER' IDENTIFIED BY 'PASSWORDREPLICA_PASS'; FLUSH PRIVILEGES; |
Configure DB replication on slave DB server
...