1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
RESOLVED:
In the slave's /etc/mysql/mysql.conf.d/mysqld.cnf I needed to comment out the 'bind-address' and 'mysqlx-bind-address' lines, stop the slave, restart mysqld and start the slave, again.
Having 'bind-address = 127.0.0.1' prevented connections from anywhere else.
Commenting it out allows access from all sources, not just localhost.
EC2 Security Group restricts access to port 3306 to just the master server's IP block.
Working great all around, now.
Thank you for your attention.
répondu il y a 3 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 9 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 2 ans