Re: Replication: Connecting Slave and Master

[Ryan Allen]

So I ran those and netstat as well to see what's going on.

On the slave I ran:

nmap -PN <master_local_ip> -p 3306

and that detected:

PORT STATE SERVICE VERSION
3306/tcp filtered mysql

So it found MySQL listening on 3306, but I read filtered state is a bit like an "inconclusive" result with nmap, so I did the other tests too. I ran the telnet test with:

telnet <master_local_ip> 3306

and that just spun endlessly and timed out. Then I tried:

netstat -tulpn

and that found:

Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 <master_ip>:3306 0.0.0.0:* LISTEN

Now I'm confused again, because if I understand these correctly, netstat and nmap are saying the port is open and being used by mysql, right? What could have happened with telnet and back at the mysql prompt?