I am trying to set Master-Server Replication.I followed the following steps,even though slave can't able to connect the master.
master ip : 10.93.210.133
slave ip : 10.93.210.211
Steps in Master Server:
1. Changes in my.cnf file
(uncommented this two lines in my.cnf file)
log-bin = mysql-bin
server-id = 1
2.Restarted mysql
3.login as root in mysql and creating new users look on this
Expand|Select|Wrap|Line Numbers
- mysql>GRANT REPLICATION SLAVE ON *.* TO 'slaveuser'@'10.93.210.211'
- IDENTIFIED BY 'slave';
4.show master status;
(for mysql file and position)
Steps in Slave Server:
Expand|Select|Wrap|Line Numbers
- 1. Changes in my.cnf file
- (uncommented this two lines in my.cnf file)
- server-id = 2
- 2.login :
- shell>mysql -u root -proot
- mysql>CHANGE MASTER TO
- MASTER_HOST=’10.93.210.133’,
- MASTER_USER=’slaveuser’,
- MASTER_PASSWORD=’slave’,
- MASTER_PORT=3306,
- MASTER_LOG_FILE=’mysql-bin.000001',
- MASTER_LOG_POS=98,
- MASTER_CONNECT_RETRY=10;
- mysql>start slave;
- empty rows affected
By seeing,mysql log on slave server ....showing an error message,can't connect to master.
Please see this step and solve my problem....did i made any mistakes in setting master - slave replication ?