You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Launch Windows Console (Run as Administrator)

Change to MySQL bin folder

cd C:\Program Files\Deepnet DualShield\mysql\bin

Login into MySQL console by entering

mysql -u root -p

When prompted, enter the password of the root mysql user.

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;



  • No labels