Cannot connect to MySQL database running on AWS

Question

public static void main (String[] args) { 
        String host = "jdbc:mysql://[email protected]:3306/"; 
        String uname = "root";
        String db = "customers";
        String password = "somepassword";
        String driver = "com.mysql.jdbc.Driver";
        int i = 0;
            try {
                Class.forName(driver).newInstance();
                Connection conn = DriverManager.getConnection(host+db, uname, password); 

                Statement st = conn.createStatement(); 
                i = st.executeUpdate("INSERT INTO users " + 
                        "VALUES ('Simpson1', '[email protected]', 'Springfield')"); 

                if(i==1)
                    System.out.println("Sucessfully Updated table");

                conn.close(); 
            } catch (Exception e) { 
                System.err.println("Got an exception! "); 
                System.err.println(e.getMessage()); 
            } 
}

I am trying to connect to an AWS DB, but I am getting the following exception and error while I run the program above:

Got an exception! Communications link failure

The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server.

Is it error in the hostname I am trying to connect to?

Naveen Vijay · Accepted Answer · 2014-06-14 11:04:57Z

2

Based on the connection string and URL of the database, I see that you are connecting to the database installed in EC2. I assume that you are trying to connect to instance from / via external internet.

Please check the following settings

Check if the port 3306 is open for the instance for the TCP protocol to your public IP in the security group used by the instance
You need to enable remote connection in your MySQL. It is a database instance level setting.

The best litmus test to confirm whether it is problem of connection / connectivity setting is to try running the above code inside the same ec2 instance in which the database instance is connected.

answered Jun 14, 2014 at 11:04

Naveen Vijay

16.6k10 gold badges75 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitry Mukhin · Accepted Answer · 2014-06-14 11:21:18Z

1

Seems that you have to open port 3306 to the world (which is not a good idea by the way and you may want to revise this in production). To do that you need to

add a permissive rule to security group set for EC2 instance with running MySQL server.
Open port on firewall that is running on instance (if any)

edited Jun 14, 2014 at 11:21

answered Jun 14, 2014 at 10:56

Dmitry Mukhin

7,0173 gold badges31 silver badges31 bronze badges

Collectives™ on Stack Overflow

Cannot connect to MySQL database running on AWS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related