-1

I have installed mysql 5X in one t2.micro instance. And Installed hadoop in another t2.micro instance.

When i tried to connect to mysql from hadoop its saying connection failure. I am able to ssh between systems. How to make communications possible at application level. Like a java program in one system to insert data to mysql table in another instance.

Piyush Patil
  • 14,512
  • 6
  • 35
  • 54

1 Answers1

1

Have you open port 3306 on your instance for incoming connection from your network ?

Also check if MySQL is bind to 127.0.0.1 in /etc/my.cnf bind-adress. You have to change it for 0.0.0.0 to listen on all interfaces.

Sylwit
  • 1,497
  • 1
  • 11
  • 20