title: Communications link failure Last packet sent to the server was 1 ms ago.
body: <p>I tried to connect to <code>mysql database</code> but I failed and this error is shown </p>
  
  <pre><code>Communications link failure Last packet sent to the server was 1 ms ago
  </code></pre>
  
  <p>and this is my code ? anyone can help me please </p>
  
  <pre><code>package android_programmers_guide.testconnection;
  
  
  import java.sql.Connection;
  import java.sql.DriverManager;
  
  import android.os.Bundle;
  import android.app.Activity;
  import android.graphics.Color;
  import android.view.Menu;
  import android.widget.EditText;
  
  public class TestConnection extends Activity {
  
      @Override
      protected void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_test_connection);
  
  
  
             Connection conn = null;
             String url = "jdbc:mysql://127.0.0.1:3306/test";
             String driver = "com.mysql.jdbc.Driver";
             String userName = "root"; 
             String password = "root";
  
  
             try {
             Class.forName(driver).newInstance();
             conn = DriverManager.getConnection(url,userName,password);
  
  
             EditText editText=(EditText) findViewById(R.id.editText1);
  
  
             editText.setBackgroundColor(Color.GREEN);
             editText.setText("Connected to the database");
  
             conn.close();
  
             editText.setBackgroundColor(Color.BLUE);
             editText.setText("Disconnected from database");
  
  
             } catch (Exception e) {
             e.printStackTrace();
             }
  
  
  
      }
  
      @Override
      public boolean onCreateOptionsMenu(Menu menu) {
          // Inflate the menu; this adds items to the action bar if it is present.
          getMenuInflater().inflate(R.menu.activity_test_connection, menu);
          return true;
      }
  
  }
  </code></pre>