[TriLUG] MySQL Replication

[matt at noway2.thruhere.net]

This and make sure that you're not getting hit with an access denial based
upon the host part of 'user'@'host', which MySQL seems to be particular
about.  Been bit by this many times.

You could use nmap to check that TCP port 3306 is open and then use a
command shell to try logging in and check the log files for error details.


> Have you checked if it is perhaps a firewall issue.  The boxes will need
> to be able to communicate with each other on the port that MySQL listens
> on.  Default port for MySQL is typically 3306.  It is also typically
> closed in most production setups.  When you open the port you should
> specify the ip addresses allowed to communicate through that port in your
> rules.
>
> Ken
>