Cant login to mysql on another droplet
I have two droplet (vlife-portal & vlife-data ) with the same configuration.
vlife-portal have a SSL.
Within both mysql.user, I have set up root@'private IP' and grant them related privileges.
And I followed the tutorial in the community to set up master & slave mysql, I tried to make vlife-portal as master and the other as slave. But after I start the slave, I find that I cant connect to vlife-portal.
Then I tested on vlife-portal in my terminal, I can connect to vlife-data's Mysql directly.
However, when I on the vlife-data, I cant connect to vlife-portal.
iptables / firewalls are not enabled.
No bind-address in my.cnf. I tried bind-address to 0.0.0.0 still not work.
*Error msg: *
ERROR 2003 (HY000): Can't connect to MySQL server on 'private IP' (110)
Could you please give me an hand on this?