Expand |
---|
title | Login to MySQL console |
---|
|
Include Page |
---|
| Login to MySql console |
---|
| Login to MySql console |
---|
|
|
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.
Code Block |
---|
|
mysql> create user 'replicator'@'%' identified by 'password'; |
Next, we need to give this user permissions to replicate our mysql data:
Code Block |
---|
|
mysql> grant replication slave on *.* to 'replicator'@'%';
mysql> flush privileges; |