Unable to connect to MySQL remotely.
We have two AWS lightsail instances (Ubuntu 14.04.5) and are trying to connect from one to the other.
Both versions of MySQL are 5.6.35.
The last thing I want to do is replication, and the replication slave MySQL log is
Slave I/O: error connecting to master '[email protected]:3306' -
retry-time:60 retries:37, Error_code:2003
appears, but before that, simply
However, you cannot connect with the following error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx'
telnet:Unable to connect to remote host:Connection timed out
I can't connect to it, so I think it's around the port, but I don't know the cause or countermeasure.
Here's what I've done.
Verify MySQL user hoge connection authorization settings
(The hoge was created with
grant replication slave on*.* to [email protected]'%' identified by 'password'; )
My.cnf bind-access comment out
Thank you for your cooperation.mysql ubuntu network unix
If the server is not LISTENing the port, the client error should be
Connection refused. I think
Connection timed out is a problem around the network (firewalls, routing, etc.).
Whether or not the server is pinged from the slave.
If the ping goes through, can you connect to a port other than 3306 (such as number 22)?
You might want to check the firewall on the client side as well.
© 2022 OneMinuteCode. All rights reserved.