☰
✕
✕
0

Mysql : mater-slave not connecting

Hi...,

i have installed and configured mysql master-slave configuration on centos. i configured all setup what it exactly appears in websites but still my replication process is not working... finally i checked master status its shows slave running status is No.... i attached that error below please guide me to solve this issue....

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master1
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000004
Read_Master_Log_Pos: 931
Relay_Log_File: slave1-relay-bin.000056
Relay_Log_Pos: 950
Relay_Master_Log_File: mysql-bin.000004
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB:

MySQL
Add a comment
nathan
asked Aug 31 2017

Answer

0

in my thoughts this error occurs due to mysql port is blocked in firewall... please check your firewall settings allow mysql port into firewall and retry the replication process........

Comments
nathan
Apr 07 2025
yes this mistake happened due to mysql port blocked in firewall...... once i allowed mysql port into firewall now the replication working fine.... thanks a lot.......
Add a comment
arunkumarak
asked Aug 31 2017
edited Oct 05 2018
Post your Answer