Page History

We need to create a pseudo-user that will be used for replicating data across all servers. The examples in this article will assume that you name this user "replicator". Replace "password" with the password you wish to use for replication.

mysql> create user 'replicator'@'%' identified by 'password'; 

Next, we need to give this user permissions to replicate our mysql data: 

mysql> grant replication slave on *.* to 'replicator'@'%';  
mysql> flush privileges;