I have been trying to setup MySQL replication for the first time. I read many articles and it appears very easy, but I guess I made a typo when setting up the slave. I am getting the following error in the error log.
2016-10-02T14:29:45.479004Z 1 [ERROR] Slave I/O for channel '': error connecting to master 'abcd123@server3:3306' - retry-time: 60 retries: 2628, Error_code: 2003
Server1 Master mysql
Server2 Slave mysql
Server3 web server.
CHANGE MASTER TO MASTER_HOST='10.0.0.1',MASTER_USER='abcd123',MASTER_PASSWORD='PASSWORD',;
In case of replication is not connecting check basic thing
Check for any error
show slave status\G;