MySQL Replication not working in E5MS
Hello All,
i need some help.
MySQL Replication not working in E5MS. I am following below steps:
On Primary server:
==================
GRANT ALL PRIVILEGES ON * TO root@'server1' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * TO root@'server2' IDENTIFIED BY 'password';
CREATE USER 'replication'@'server1' IDENTIFIED BY 'replication';
GRANT REPLICATION SLAVE ON * TO 'replication'@'server2' IDENTIFIED BY 'replication';
FLUSH PRIVILEGES;
On Secondary server:
====================
GRANT ALL PRIVILEGES ON * TO root@'server1' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * TO root@'server2' IDENTIFIED BY 'password';
CREATE USER 'replication'@'server2' IDENTIFIED BY 'replication';
GRANT REPLICATION SLAVE ON * TO 'replication'@'server1' IDENTIFIED BY 'replication';